Re: Weird Oracle Performance Problem

From: Jon Leatherwood <leatherwoodj_at_goalamo.com>
Date: 18 Jul 2001 10:11:42 -0700
Message-ID: <d8008ef7.0107180911.4313930c_at_posting.google.com>


Found out the problem. Seems the DataEnviroment doesn't handle connection to oracle very well unless VB is installed on the machine and the project has been run at least once in the IDE. Dont know why...but when i dropped using DE and just made a global connection object the problem disappeared.

leatherwoodj_at_goalamo.com (Jon Leatherwood) wrote in message news:<d8008ef7.0107180631.743b94c8_at_posting.google.com>...
> We've come across a perplexing problem. We developed an application
> using VB 6 w/ sp5 which connects to an Oracle 8.1.7 instance using the
> Oracle ODBC Driver. On any of the 4 development machines used by our
> group, the application connects quickly and all queries perform
> well(return data quickly). When we install the package onto a test
> machine, the connection is still made quickly; however, the
> performance of queries drop dramatically..(on development most queries
> returned data in under 3 seconds..on test machines..same queries take
> on average 30secs or more). We've checked tnsnames, odbc
> configurations and registry settings and can not find any difference
> in settings from development enviroment to testing enviroment. Under
> both enviroments, the application is connecting to the same instance
> of oracle and our development enviroment even has more hops to the
> oracle instance then the test machine. Can anyone give any possible
> suggestions on avenues of investigation (or a possible solution).
>
> Thanks,
> Jon
Received on Wed Jul 18 2001 - 19:11:42 CEST

Original text of this message