Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Re: DBI/mysql gathering all rows on execute

by jdtoronto (Prior)
on Nov 24, 2003 at 20:33 UTC ( #309669=note: print w/replies, xml ) Need Help??


in reply to Re: DBI/mysql gathering all rows on execute
in thread DBI/mysql gathering all rows on execute

This method can be problematic. If there is any other activity on the table then the results will not be returned in the same order on succesive accesses and so you have a chance of missing some records completely or getting some twice. It is in fact possible, but not common, for consecutive executes to return the recirds in a different order even when no other activity has taken place on the table, particularly when using Perl 5.8.1 or later.

jdtoronto

  • Comment on Re: Re: DBI/mysql gathering all rows on execute

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (1)
As of 2020-10-25 08:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (249 votes). Check out past polls.

    Notices?