Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Testing transactions

by mpeppler (Vicar)
on Jan 24, 2008 at 14:12 UTC( #664032=note: print w/replies, xml ) Need Help??


in reply to Testing transactions

As roboticus says - open two or more database connections (or client apps) and run requests with varying degrees of delays.

I presume that the transactional part of the system is handled at the database level. Even so, if Dbix::Class offers a high level of abstraction over what actually happens in the DB (something I don't know as I haven't used it) then you should be careful of things like deadlock situations where locks on different resources are acquired in a different order in two processes, and each process is waiting to acquire a lock that the other already holds.

And keep in mind that you are likely to find race conditions in places where you didn't think that they were likely to appear...

Michael

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (8)
As of 2016-08-30 12:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (417 votes). Check out past polls.