Home » RDBMS Server » Performance Tuning » Query Performance
Query Performance [message #134388] Wed, 24 August 2005 13:23 Go to next message
Messages: 16
Registered: April 2005
Junior Member

I have a VB5.0 application running in NT OS against Oracle 7.3 database.One of the query takes 3 secs to fetch data.

Now, we are running the same VB application in Windows XP against same database, which takes 15-20 secs to fetch data.

I'm using ORADC.OCX to connect to oracle from VB.

Anyone , please throw some light.

Re: Query Performance [message #134608 is a reply to message #134388] Thu, 25 August 2005 14:25 Go to previous message
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

This doesnt seem to be a database problem ...as long as the SQL retrieves the data in the anticipated time..that cannot be a database performance issue .. you need to consider the server load and cpu issues also into consideration for query tuning ..

-sai jeedigunta
Previous Topic: how to figure out checkpoint running slow
Next Topic: tune the query
Goto Forum:

Current Time: Mon Nov 28 06:08:01 CST 2022