Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO RecordSet.GetRows
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00599884
Message ID:
00607764
Views:
32
Hi Alexander,

I used just the Execute method because of the time it takes for recordset translation.

I'll be looking forward to future updates. Let me know when you get them out here for download.

Thanks,
Steve

>>60 secs which was pretty good (much better than with using .GetRows) but still not as good as ODBC which clocked in at 44 secs. We've decided to continue using ODBC but do recognize that we will be changing in the future to OLE DB, and probably sooner rather than much later.
>
>Could you specify, 60 secs is the time of RsToCursor or Execute method? I'd like to knows result for further development. Now connection object uses server-side cursor and I'm thinking about adding of ability to use client-side cursor.
>The speed of OLEDBFox will be improved in near future by means of using bulk rowsets and more effective storing data into cursor. But it will not be much faster than ODBC.
>
>Alexander
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform