Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1072221]
LanX is not affraid of Trump ...
LanX ... me is scared of people voting for Trumps
[erix]: until good old Putin lobs a bomb on Berlin :)
[Your Mother]: “I’m afraid of Americans…”
[Your Mother]: “No one needs anyone / They don’t even just pretend…”
[erix]: they've stuck nuclear missiles in Kaliningrad - they can just reach Berlin :)
[LanX]: naaah! Putin wouldn't nuke all the Russians in Berlin
[Your Mother]: Putin is a bad guy but he’s not that kind of bad guy. (Who would launch.)

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2017-01-20 00:52 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (173 votes). Check out past polls.