On Mon, Feb 23, 2009 at 6:54 PM, Sam Mason <s...@samason.me.uk> wrote:
Depending on where these are on disk and how fast your disks are this > could take up to 30 seconds. This does not sound very inspiring :-) Would throwing more hardware (memory, faster CPU) at the server improve the situation? > If you want this sort of thing to go quicker you could try CLUSTERing This can help because all other queries to this table alway filtered/grouped by context_id field. I will try that. Thanks a lot, Sam!
