On Aug 4, 2009, at 7:18 PM, Martin Zvarík <mzvarik@xxxxxxxxx> wrote:
I need to do about 5 queries:
1) pick the top visited articles
2) pick the recent articles (limit 10)
3) pick the most commented articles
etc.
Now, I have 2 choices:
1) SELECT ALL records and use PHP for conditions
2) do 5 queries on MySQL
---
Imagine it has 500 long text articles.
Which of these 2 options is better for performance?
Thanks,
Martin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Ensure that you can return the same data for each type of query and
then join then with a UNION statement and do it all in one query
Bastien
Sent from my iPod
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
