Storing big queries in Application Scope to search?

2003-12-18 Thread rob.stokes
Hi all, Anyone know why this won't work? Its got me stumped! Also, any comments on whether it's good practice to use the application scope to store a large set of query results would be useful (i.e. to refer to that set of results in a loop instead of hammering the database 100's of times...). Use

Re: Storing big queries in Application Scope to search?

2003-12-18 Thread Pete Freitag
[EMAIL PROTECTED] wrote: > Hi all, > > Anyone know why this won't work? Its got me stumped! Also, any > comments on whether it's good practice to use the application scope to > store a large set of query results would be useful (i.e. to refer to > that set of results in a loop instead of hammer

Re: Storing big queries in Application Scope to search?

2003-12-19 Thread Calvin Ward
How would you make the cached query solution viable on a load balanced solution with non-sticky sessions? - Calvin   - Original Message -   From: Pete Freitag   To: CF-Talk   Sent: Thursday, December 18, 2003 5:27 PM   Subject: Re: Storing big queries in Application Scope to search

RE: Storing big queries in Application Scope to search?

2003-12-19 Thread rob.stokes
ot;)# -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 19 December 2003 10:11 am To: CF-Talk Subject: Re: Storing big queries in Application Scope to search? How would you make the cached query solution viable on a load balanced solution with non-sticky sessions? - Calv

Re: Storing big queries in Application Scope to search?

2003-12-19 Thread Calvin Ward
 From: [EMAIL PROTECTED]   To: CF-Talk   Sent: Friday, December 19, 2003 6:31 AM   Subject: RE: Storing big queries in Application Scope to search?   Pete / Calvin,   What I really wanted to know is is storing this large query in an application scope and searching the structure using a function su