|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Help me with this code... |
|
From: |
Bullschmidt |
|
Date: |
5/21/2003 11:51:29 PM |
|
IP: |
205.188.208.39 |
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 type (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,
J. Paul Schmidt - Freelance ASP Web Developer
www.Bullschmidt.com - Creating "dynamic" Web pages that read and write from databases...
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
