I should also point out that when I used the primary key caching technique
I was doing a full-text search against a Verity collection to return the
primary keys and then using those to get the details out of a database. So
in my particular case, I had to do two queries (one against verity, one
Interesting. That's basically what I do at SMARTERyellowpages.com for
full-text queries, except I store the list of primary keys in a cached
query. For example, using "office" as a search term in
www.SMARTERyellowpages.com I find 1941 Listings that I can page thru 50 at
a time.
For drill-dow
Instead of querying all the data for the entire list on every page (even
with caching), you an often get better results by just querying the primary
keys first, and then query the data for the 50 records you're displaying in
this page--filter by primary key is very fast. Then pass the complete
As I understand your case, this is where cached queries really shine. I
have all kind of 50 results per page at www.SMARTERyellowpages.com where
cached queries do the job. My understanding from below is that your users
select parameters from each of a couple of dozen columns. So each user
wi
>It is my understanding of/experience with query caching that results are
>cached based on the name of the query, and not the actual "guts" of the
>query, so having multiple users each with their own dynamic queries but all
>run under the same query name will mean that only the first cached quer
-
From: "Pete Ruckelshaus" <[EMAIL PROTECTED]>
Date: Fri, 17 Jan 2003 09:02:22 -0500
Subject: Next N" Navigation and query caching theory question
> Hi,
>
> I am rebuilding my employer's bug tracking application; quite a job,
> but it's been fun (seriou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| needs to get run again? Should I do something like append the
| CFTOKEN for that user's session to the query name so that it is
| unique? Or should I store the query output as an array in a session
| variable?
store them in a session structure key
Hi,
I am rebuilding my employer's bug tracking application; quite a job, but it's been fun
(seriously, plus I get to be a hero to hundreds of developers who have been using the
old, ugly, slow, and completely un-user-friendly app that this is replacing). I'm at
the point where everything works
8 matches
Mail list logo
