Locktype and performance

From: Apostolos Dimopoulos (adimop_at_dreamtech.gr)
Date: 11/28/03 

Date: Fri, 28 Nov 2003 17:00:59 +0200

Hi,

I am using the ADO controls with Delphi 7 and SQL Server 2000 to populate a
control with data from a large table. Even though I would expect the
combination of adUseServer / adOpenForwardOnly / adLockReadonly to offers
the best performance, I see that the best performance - with great
difference is obtained when using adUseServer / adOpenForwardOnly /
adLockOptimistic or adLockBatchOptimistic.
Also adLockOptimistic takes no locks for reading as expected but
adLockReadonly takes select locks.
Any explanation regarding this performance behaviour?

Thanks in advance,
Apostolos