On Feb 10, 2010, at 11:48 AM, [email protected] wrote:
> Also, I really did not want to use PHP array sorting cause I feel SQL is
> almost always the better solution.
If you're database is bottlenecking your application because of too many random
reads, moving the sorting to php can help you out. But it becomes tricky when
you need to do a complicated ordering, only need to get a few rows at a time,
and the table is too large to be put in memory for php. Then maintaining a
summary table can help or caching the query so you at least need to perform it
less times.
Thanks,
Rob
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
