Permalink for Comment #1326590999 by corybill

, comment by corybill
corybill UMMMMMM....why in the hell are you locking down an entire table on a database request. You should be locking a single cell or single tuple on updates, inserts, & deletes and only the tuples you are retrieving your SELECT statements. Connection Pooling is used and databases use an 'all or none' mentality with updates. The architecture used of locking an entire table unnecessarily slows down client server response time and seems to be architecturally inferior.

Is there a reason why you are doing this? I'd be really interested to hear because I'm sure you have a good reason, as all programmers usually do.

Thanks for an amazing site!

Cory


Phish.net

Phish.net is a non-commercial project run by Phish fans and for Phish fans under the auspices of the all-volunteer, non-profit Mockingbird Foundation.

This project serves to compile, preserve, and protect encyclopedic information about Phish and their music.

Credits | Terms Of Use | Legal | DMCA

© 1990-2024  The Mockingbird Foundation, Inc. | Hosted by Linode