Re: About Disconnected Record Sets
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Tue, 18 Apr 2006 14:04:04 +0100
I am using 'Find' while Deleting and updating records within thefor
recordset. My understanding is the Find will check the disconnected set
the record that matches the Find criteria and fetches the record from the
server if no record matching the criteria is found. Is this assumption
right?
If it is disconnected, how could Find _ever_ connect to the server?
In any case, why should the Server hold a record at all that matches the
criteria?
What if there is no record at all on Recordset or Server that matches the
criteria?
The answer is no.The assumption is not right.
Why don't you read the Microsoft online documentation on Find on MSDN?
See here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthfindmethodado.asp
Find just looks for the record in a client-sided Recordset.
If nothing is found that is it. No further lookups.
It would not even lookup if connected either.
Any ideas why the performance is bad while using disconnected recordserver
sets for Find? If anything, it should be as bad as it was while using
side cursor because at that point, I used to fire a SELECT queryeverytime.
Find just does a linear search for your record.
If you want it faster you need to do
Fld.Properties("Optimize") = True
for the field you are finding on and don't forget to do
Fld.Properties("Optimize") = False
when you have finished.
See here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprooptimizepropertyrds.asp
Stephen Howe
.
- References:
- About Disconnected Record Sets
- From: Madz
- About Disconnected Record Sets
- Prev by Date: About Disconnected Record Sets
- Next by Date: Re: Run-time error -214722164 (80040154) Class Not Registered
- Previous by thread: About Disconnected Record Sets
- Index(es):
Relevant Pages
|
|
