Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

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...


Log In?

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (9)
As of 2016-10-27 17:51 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (366 votes). Check out past polls.