Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

Re^7: Multiple write locking for BerkeleyDB

by sgifford (Prior)
on Apr 24, 2008 at 14:33 UTC ( #682637=note: print w/ replies, xml ) Need Help??

in reply to Re^6: Multiple write locking for BerkeleyDB
in thread Multiple write locking for BerkeleyDB

I suspect you will get much faster results if you update just one table with all three pieces of data in it. Also, as others have said, make sure you have an index on whatever you use in your WHERE clause for the UPDATE. And, if your count_cross column is the sum of count_in and count_out, just leave it out and calculate it when you need it; this will help (at least a little) if reads are much less frequent than writes.

In my tests elsewhere in this thread, I was able to get about 132K updates/min out of MySQL on a 2-CPU 1GHz Pentium III, so unless your machine is much slower there is probably some performance to be found somewhere.

Comment on Re^7: Multiple write locking for BerkeleyDB
Select or Download Code

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2015-11-29 19:27 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (752 votes), past polls