On Aug 4, 2009, at 7:18 PM, Martin Zvarík <mzva...@gmail.com> 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

Reply via email to