Re: How to manage search results?

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



On Lu, 2001-12-10 at 13:06, Andrew McMillan wrote:
> > I also assume your query doesn't take more than a second to run.
> 
> No, the users can save query criteria and so forth, and queries can take
> a minute or two to run.
so for adding/refining/substracting you use in one big query UNION,
INTERSECT, EXCEPT instead of a temporary table?

Is it ok with your users to run a search which takes say 30 secs,
see first 10 results, then wait again 30 secs to see the next 10 ?
(if you run the query again...); perhaps I misunderstood something

> The underlying data being queried changes a fair bit.  This is a news
> database, so the users want their queries to stay constant, but the
> results to vary. 
yes, same here. We have members (about 13000) and staff performs
searches with criterias like state of licensure is xx or
number of comments > y. (The criterias expand as staff requests)
But the data queried doesn't change as often when just browsing
through search results, so I'd rather keep a list of IDs in a 
temporary table than run the query every time they want to see
next page.

Once one has these results they can go to the individual view of
a member and change some data then return to browsing results,
or mass-mail everybody in search results. Again, in the mass mail
script is faster to start sending mail right away than perform
the query (queries) again and then start with the mail.

thanks
-- 
Marius Andreiana
--
You don't have to go to jail for helping your neighbour
http://www.gnu.org/philosophy/



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux