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

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

 



Just shooting from the hip, I would say the faster method would be to create
the 5 different mysql queries.  The amount of time taken up by retrieving
500 articles of either blob or text can add up to a significant amount of
time, whereas 5 queries that average 10 results per query would result in
~90% decrease in reading data from the database.  Performing aggregate mysql
functions for most commented and etc are generally very fast and can be done
much more quickly than retrieving the whole article, passing to php, storing
to memory and then manipulating the data.

Thanks

patrick



2009/8/4 Martin Zvarík <mzvarik@xxxxxxxxx>

> 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
>
>

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

  Powered by Linux