Subject RE: [ib-support] Understanding Transaction-behaviour
Author Fabricio Araujo
If 6.5 used record locking, it would be a HUGE bless!!!! This monster
uses PAGE and table locking.
MSSQL 7 & 2k uses page,record and table locking.

On Thu, 24 Jan 2002 15:32:46 -0000, Richard Pendered wrote:

>From what I remember about MS SQL 6.5 is that it uses record, row and table
>locking within its transactions. I presume that it would be the same in 7
>and 2k.
>So yes IB/FB are the only RDBMS to use a versioning model.
>
>Rich P...
>
>-----Original Message-----
>From: akahanek@... [mailto:akahanek@...]
>Sent: 24 January 2002 15:25
>To: ib-support@yahoogroups.com
>Subject: RE: [ib-support] Understanding Transaction-behaviour
>
>
>At the end of the first arcticle Bill Todd writes, that "At this writing
>Inprise's InterBase is ... the only one to use the versioning model".
>Is it true? Does anybody know if MS SQL Server is using versioning model
>or not?
>Ales
>
>-----Original Message-----
>From: Paul Beach [mailto:pabeach@...]
>Sent: Tuesday, January 22, 2002 11:00 AM
>To: ib-support@yahoogroups.com
>Subject: Re: [ib-support] Understanding Transaction-behaviour
>
>
>Have a look at:
>
>http://www.ibphoenix.com/ibp_bill_todd_mga.html
>
>and
>
>http://www.ibphoenix.com/ibp_oit.html
>
>Regards
>Paul Beach
>Main Tel (UK):+44 (0) 1844 354465
>Mobile: (UK): +44 (0) 7764 188603
>http://www.ibphoenix.com
>For all your upto date Firebird and
>InterBase information
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to
>http://docs.yahoo.com/info/terms/
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


[]s Fabricio
Systems Developer