Rev cgi search question

[Kee Nethery]

We do stuff like this all the time. caching data locally.

The deal is we store last datetime changed for each row in each table  
in our database. Every time the row gets changed the datetime gets  
updated.

The various systems that use the data search the local data cache,  
not the external database.

Before doing the search we do an update to the cache and to do that  
we keep track of the lastdatetime when the database was looked at and  
we look for any rows that have changed since then. If the result set  
is zero, then the cached data gets used as is and the lastdatetime  
gets incremented in the cache.

If the resultset is not zero, we grab the changes, and incorporate  
them into the data set and then update the cache date.

Then once the cache is updated, we do the search.

If the cache is empty, or the last cache check date is empty, we do a  
complete pull from the database.

Kee


On Jan 14, 2008, at 11:28 AM, Richard Miller wrote:

> I'm looking for suggestions on how to accomplish the following.
>
> 1. User starts a search of my text-based database (via browser and  
> Rev cgi).
> 2. My app finds the results (which are a series of line numbers...  
> possibly as many as 1000)
> 3. I now want to store those results so that when the user brings  
> up a data page resulting from the search, they can go back to the  
> results (presumably to go to another data page from the results)  
> without having to re-do the search or use the back-button on their  
> browser. I know how to store the results within a link (i.e. http:// 
> www.results.com?results=1,2,3..."), and I'm using this in various  
> places already. But this won't work for me in all cases.
>
> I'm guessing one solution might be to issue a temporary id number  
> and connect that to a given users search process. The results could  
> then be stored in a file on the server under this ID, with this  
> page liquidated after some period of time (30 minutes? 60  
> minutes?). Would this work or is there a better way to handle this.
>
> Thanks.
> Richard Miller
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




-------------------------------------------------
I check email roughly 2 to 3 times per business day.
Kagi main office: +1 (510) 550-1336