| query speed [message #66231] |
Mon, 11 February 2002 06:20  |
Kane
Messages: 15
Registered: November 2001
|
Junior Member |
|
|
Guys:
My company recently upgraded the network system and a 5 minutes query before runs for an hour now. I think it's the firewall thing on out LAN but no idea how to fix it. Anyone has any clue?
Kane
|
|
|
|
| Re: query speed [message #66232 is a reply to message #66231] |
Mon, 11 February 2002 08:37  |
Sreenivasan Balaji
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
Kane,
You must first test the network speed with
utilities such as 'snoop'. You need to measure the incoming and outgoing speed of the packets.(assuming that you are using Oracle on UNIX and TCP)
Check if port#1521 is loaded with heavy packet
traffic. If port# 1521 is overloaded, try using
another port for this query.
Next check to see if you are using any database links in your query. This can slow you down.
You may have to localize the remote tables.
Check if the Query itself can be run using a
stored proc on the server side if its not already
in a stored proc.
Lastly, if you are using a middleware such as ODBC or JDBC try usng a different driver.
let me know if this helped.
Balaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
