Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: weerning20021209

Message # 1014830:
Date: 12/22/02 18:39
By: Tbull Profile
Subject: Use MySQL-operations where possible

Your article is informative and very valuable. I must take exception with your indication to do math in PHP versus MySQL. No matter what DB you are using, my experience is that the DB engine is significantly faster at processing its data and if the query is correctly structured returns only those rows or sets that are appropriate for use. If you find that you are doing significant workload processing of row sets using math functions in PHP you may find it advantegous to evaluate the data constructs of your MySQL tables and optimize the strategy of the queries being used to return them.

As an example using a query which evaluates several thousand rows and performing calculations on multiple columns using PHP can take several minutes while the MySQL engine can return the same result in seconds. Allowing the display to be accomplished using PHP with final tweaking.

Previous Message | Next Message


Comments:
And how about those fairies? Freeflashonlinegames Com 12/07/04 09:45
About mySQLRobin Ekman04/13/04 10:02
RE: DO NOT Use HTML Instead of PHP When Possibletim03/25/04 07:27
RealityBen Smith01/02/03 05:04
More on templatesBen Smith01/02/03 04:51
RE: Benchmark first - not lastJesus A. Domingo12/24/02 14:42
RE: ExcellentReiben12/24/02 05:19
RE: iframes!? what are you thinking about!Henry Blackman12/23/02 18:21
RE: DO NOT Use HTML Instead of PHP When PossibleGarcia Hurtado12/23/02 14:12
Use MySQL-operations where possibleTbull12/22/02 18:39
RE: iframes!? what are you thinking about!marion weerning12/19/02 18:06
RE: IFRAME & Search Enginesmarion weerning12/19/02 18:04
Use templates, not dropping in and out of PHPBryan Alsdorf12/19/02 14:20
RE: The perils of over-optimizationRicky Palandeng12/19/02 08:05
Benchmark first - not lastMatt Friedman12/18/02 21:34
IFRAME & Search Enginesg_a_t_e12/18/02 07:09
Excellent articlevijay khanna12/17/02 07:46
MySQL QueriesAlex Dow12/17/02 01:42
iframes!? what are you thinking about!Alex Dow12/17/02 01:37
ExcellentH3X12/16/02 15:02
DO NOT Use HTML Instead of PHP When PossibleBrad Touesnard12/15/02 20:00
The perils of over-optimizationSam12/15/02 16:56
Dates in PHP and MySQLMarcus12/14/02 11:51
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.