Re: How to manage search results?

From: Marius Andreiana <marius(at)wdg(dot)ro>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: pgsql-php <pgsql-php(at)postgresql(dot)org>
Subject: Re: How to manage search results?
Date: 2001-12-10 12:19:05
Message-ID: 1007986746.8625.0.camel@aurora.wdg.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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/

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Andrew McMillan 2001-12-11 22:22:56 Re: How to manage search results?
Previous Message Andrew McMillan 2001-12-10 11:06:34 Re: How to manage search results?