Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: Store results by search term, not session ID

by MrCromeDome (Deacon)
on May 09, 2002 at 21:21 UTC ( #165522=note: print w/replies, xml ) Need Help??

in reply to Store results by search term, not session ID
in thread Database searches with persistent results via CGI

If drive space is not an issue on the database server, is there harm in making a temp table in the following format?

- search criteria
- result column 1
- result column 2
. . .

The reason I ask being that my search results will always have the same column names and ordering.

And, as for storing the criteria in the table, I imagine I can consolidate it into some sort of string like:

then index that field, consolidate a query into that format, and see if I get a match in the database? If not, cache some more data?

Thanks for the help thus far :)

  • Comment on Re: Store results by search term, not session ID

Replies are listed 'Best First'.
Re: Re: Store results by search term, not session ID
by perrin (Chancellor) on May 10, 2002 at 03:38 UTC
    Hmmm... I had a reply node here and it seems to have been erased when I replied to ask below in the same thread. Very strange.

    Anyway, the gist of it was that you can use the table structure you suggested or serialize the whole result data structure into a blob column using Storable.

    Also, make if your search criteria are in a hash make sure you sort them before you use them as the result key. Hashes can return their keys in a different order, even when the keys are identical.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://165522]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2022-08-13 16:26 GMT
Find Nodes?
    Voting Booth?

    No recent polls found