Martin Zvarík 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

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.

For none of these situations you've mentioned do you need the text for the articles. Don't select it if you don't need it.

Which of these 2 options is better for performance?

Database. Not only for performance but for memory (imagine 100,000 articles).

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to