| Query Performance [message #134388] |
Wed, 24 August 2005 13:23  |
jilpangs
Messages: 16
Registered: April 2005
|
Junior Member |
|
|
Hi,
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.
Thanks
Jils
|
|
|
|
| Re: Query Performance [message #134608 is a reply to message #134388] |
Thu, 25 August 2005 14:25  |
vjeedigunta
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
