Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Extracting Numerous records

by FloydATC (Chaplain)
on Jan 27, 2014 at 13:23 UTC ( #1072221=note: print w/ replies, xml ) Need Help??


in reply to Extracting Numerous records

I could be way off since I know nothing about the actual application, but here's what I think:

To keep results consistent for the end user in the face of potential updates to the database between the initial and follow-up requests, I would probably keep a separate table containing the active "sessions" and the query results associated with that session. (Or store them by other means)

To illustrate:

  1. User searches for "XXXX" which yields 3 hits(1, 4 and 5)
  2. Database record 5 is updated and no longer matches "XXXX"
  3. User requests match no.3, should receive record 5 which would no longer match if the initial query was executed again. He would probably be very confused if that record suddenly wasn't available. ("You just told me there were 3 matches!") Even if this will potentially send outdated info.
-- FloydATC

Time flies when you don't know what you're doing


Comment on Re: Extracting Numerous records

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2015-07-01 23:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (25 votes), past polls