|
Posted by J.O. Aho on 10/23/06 04:30
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
Navigation:
[Reply to this message]
|