Re: transactions -- whole table locked from reads too?

2001-02-18 Thread Jeremy D. Zawodny
On Fri, Feb 16, 2001 at 01:05:51PM -0500, Scott McCool wrote: > > My guess is that this is what was happening. I'm not sure of any > way to confirm it though, how do I ensure that my select() is > happening from a different database page then the insert? Realistically, you can't. It's a guessin

RE: transactions -- whole table locked from reads too?

2001-02-16 Thread Scott McCool
ry 16, 2001 10:38 AM To: [EMAIL PROTECTED] Subject: Re: transactions -- whole table locked from reads too? Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a

Re: transactions -- whole table locked from reads too?

2001-02-16 Thread Heikki Tuuri
Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a page level lock on the page where you try to do the select. Then it is correct behavior of the database that y