Subject Re: The age old 'count' issue...
Author vladman992000
--- In, "Martijn Tonies" <m.tonies@...> wrote:
> Does this mean that a "View Page 2" link -reruns- the search query? If so,
> you
> should really rethink that strategy.

Yes, you are correct. I'm definitely up for rethinking this whole thing, but gotta keep those users happy :)

> Storing the search result into a table (create a "header table" with a
> timestamp for
> the query, use a "detail table" for the actual result records, run a job
> every so often
> to delete old searches) really is the way to go.

I might be able to do something like that for some queries. The problem is that the user typically filters all views and in a way that I'd have hundreds if not thousands of those queries being stored persistently and being invalidated every second or so. I could certainly cut down some of the searching by doing it this way. But I don't think it would work for most of my users and their ever-changing searching needs.