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

Re^5: DBD::SQLite bulk insert woes

by Marshall (Prior)
on Sep 12, 2012 at 07:17 UTC ( #993156=note: print w/ replies, xml ) Need Help??


in reply to Re^4: DBD::SQLite bulk insert woes
in thread DBD::SQLite bulk insert woes

I suspect that there are some problems with IMMEDIATE.
http://www.sqlite.org/lang_transaction.html

I am not a DB guy and I don't know the "best" answer, if there even is one.

I mean if process A reads the DB and then wants to update some record, but process B has read the same record and want's to update it too! Who's update "wins"? Maybe this is a complicated thing where if process A had known about process B's update in advance, it would have made a different decision? In other words, what process A will do is "nonsense" given what process B just did. If this is a single field in a record, maybe a password, I can see it..last guy wins and there is really not a problem. If each update is "atomic" and self consistent, then maybe this IMMEDIATE keyword is not necessary? I defer to the DB guru's here.


Comment on Re^5: DBD::SQLite bulk insert woes

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (11)
As of 2015-07-30 09:20 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 (270 votes), past polls