|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
The Right Cursor |
|
From: |
J. Paul Schmidt |
|
Date: |
5/16/2001 2:59:09 AM |
|
IP: |
205.188.195.38 |
Here is something you might find helpful to be able to get ADO's RecordCount to work correctly:
Cursor & LockType Performance Report - 6/27/1999
http://www.4guysfromrolla.com/webtech/062799-3.report.shtml
Test was done for inserting recs instead of just getting them.
Use adOpenForwardOnly cursor (the default) whenever possible for speed, but use adOpenStatic if want to use objRS.MovePrev or objRS.RecordCount.
Use adLockReadOnly lock type (the default) whenever possible for speed, but use adLockOptimistic when updating and deleting or adLockPessimistic if leaving a recordset open for editing which of course one shouldn't do on the Web anyway.
Best regards,
-Paul
J. Paul Schmidt, MBA
Databases on the Web
http://www.Bullschmidt.com |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
