|
|
Posted by IchBin on 10/23/06 20:03
J.O. Aho wrote:
> ZeldorBlat wrote:
>> maxdamage wrote:
>>> Well, I was wondering if it would be better to do a series of smaller
>>> queries (about 5 - 10) and use less overhead on the PHP end or do one
>>> big querry that would fill a huge array (maybe 50x10) and use a ton of
>>> overhead.
>>
>> One big query. Trips to the database are generally expensive and a 50
>> x 10 array isn't very big at all. If all else fails, try the two and
>> see which performs better.
>
> Keep in mind the distance to the mysql server from the machine running
> the php script. The further away the more risk for lag.
>
>
> //Aho
Figured I would touch on this. Is there any question about the
performance of queries or this just the php end? If so how about
normalizing the database? Every little bit would help.
--
Thanks in Advance... http://ichbin.9999mb.com
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
______________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
Navigation:
[Reply to this message]
|