Re: 500 records (articles) - SELECT ALL or USE WHERE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 







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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux