General information
Category:
Coding, syntax & commands
>>>>
>>>>It's been that way since MDAC 2.1. And as John states, with a few tweaks it can run even faster.
>>>>
>>>
>>>What? That is not what John said. He said that the results are not meaningful. Using client-side recodsets *<g> will make the results much slower, and will be a more fair comparison to SPT.
>>
>>You're right, John was saying something else.
>>
>>What I was trying to point out is that since MDAC 2.1 ADO is faster than SPT regardless of cursor type, even with the use of the same ODBC connection as opposed to the more direct OLEDB (when available).
>
>JC,
>
>Cool...so it is faster, but certainly not more than twice as fast *g*. I'm setting up wrappers to deal with SQL Server via ADO as we speak...using OLEDB, of course :)
Right, I guess the numbers did look very dramatic at first.
If you're doing code for calling stored procedures, check my other reply about the tool I posted on the UT downloads "Get sp parameters", should come in handy.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only