SQL toolkit slower than Microsoft Query

[Pvakh]

I have upgraded my SQL toolkit to the latest version and mentioned that it works much slower than previous version. Also I tried to compare execution time of the same query in Microsoft Query from Excel. Microsoft query works 100 times faster! Of course I compared just query time without connection time. I have Oracle 7 database and running Windows 98 on my machine. Does anybody know how to speedup Labview SQL?
Thank you in advance,
Peter

[Dennis_Knutson]

I haven't done any speed comparisons but lately I've been using LabSQL from Jeffrey Travis's LabVIEW Open Source Tools at http://www.jeffreytravis.com/lost/.

[Aaron Marks]

The old SQL toolkit dealt directly with the ODBC drivers through embedded CINs. The New DataBase connectivity toolset used the Microsoft ADO activeX tools for its connection. There may be a little more overhead involved, but I would not expect it to significantly slow the process. If you want to speed things along though, you might want to look into using the paramaterized technique. There are example programs that ship with the toolkit to demonstrate this.

[Gerrit-Jan Linker]

When getting data from Excel to Oracle you could consider using
SQL*XL. Have you tried that? SQL*XL bridges Oracle to Excel. Oracle
database access is than native from Excel. You can fetch data straight
into Excel or push data out to Oracle without any programming (if you
want you can still executed insert statements that you have
programmed).

Have a look at SQL*XL at www.oraxcel.com

Regards, Gerrit-Jan Linker