Re: strategies for optimizing read on rather large tables

On Sat, Jun 04, 2005 at 01:18:04PM +0200, PFC wrote:
> Then write your query as :
> select advert_id from acr_cache where category_id = ? and region_id = ?
> order by category_id, region_id, XXX limit 20;

this is great idea - i'll check it out definitelly.

depesz