General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi!
>To correct your statement, my test evaluates the elapsed times between data retrieval processes using ADO with an OLEDB provider and SPT that can only use an ODBC driver, in turn. The tests I've run with this code show that the ADO code runs slightly faster than its SPT counterpart on most rowsets.
You need to retrieve data from ADO recordset in order to make your tests more correct. Let's add something like JCRS2DBF into your test and see result. I'm sure that SPT will be much faster (even with VFPCOM instead of JCRS2DBF).
>The comparison you mention was probably obtained using C++ code that used the OLEDB API directly.
Yes, it's a COM server built in VC++ using ATL and OLEDB consumer templates. I think, it's not a bad idea to have something similar embedded into next release of VFP.
>Now you are saying you did a test using VFP and OLEDB directly, I'd like to see your code, because up until now I was under the impression that VFP could not use the OLEDB API directly, other than through ADO.
It's my personal project and currently I have no enough free time to complete this work and place it on UT. But I'll send it in its current state on your email ASAP.
Previous
Next
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