On Win XP or 2K system, my C++ program connects to a Excel Database using ODBC . I am not too happy with the performance of my queires, hence would like to tweak some parameters.
In the Win Registry, If I look under ODBC.INI, and under the Excel Files\Engine\Excel , I can see that there is a Parameter called Threads, along with others like: ImplicitCommitSync, UsecommitSync..etctec
Do you what the parameter THread stands for ?
If I clik on it, it says, # of Threads = 3.
does it mean, the driver uses 3 threads ? can i increase the number to get superior performance?