|
|
Posted by d on 11/01/06 11:25
"maxdamage" <KevinKaran@gmail.com> wrote in message
news:1161541669.112180.213200@k70g2000cwa.googlegroups.com...
> 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.
It all depends on what you're doing and how your database is set up. Try
both ways, benchmarking each, and use mysql to explain the queries. make
sure your indexes are set up correctly, and that the MySQL optimiser is
doing what you expect.
Sometimes it's "cheaper" to let MySQL do the work, sometimes PHP. It varies
from problem to problem.
dave
Navigation:
[Reply to this message]
|