I cant seem to get the odbc connection to run in asynchronous mode. I have tried both Oracle's latest drivers as well as Microsoft's latest drivers. I have my app display the mode right before the SqlExec command and it states that I am in async mode but I notice that execution does not continue until the server has looked up the results. I have put some debugging code around the first SqlExec and the following SqlExec(which checks for the completion of query). And 95% of the query time is always spent in the first SqlExec.
We are running Oracle 8 on NTServer v4.0 and a VFP5 app on Windows95 workstations. It is a customer billing application that is looking up usage information during billing time. It looks up usage info for about 2000 customers. Each query takes anywhere from 2 to 7 seconds. That is another question I have. Its seems that Oracle is rather slow at returning the requested results. Is there something that can be changed on the server so that it can handle alot of small requests in a row? Like some kind of option that tells Oracle not to allocate and deallocate memory and such each time the app makes a query and that the app will tell it when its done or something????
As you can tell this is my first experience with Oracle and I have alot of questions. Anyone willing to discuss this please reply. Thanks.