Re: Oracle V7.1 show-stopping performance problem

snowden_at_haven.ios.com (Roger Snowden) wrote:
>Greg D. (nngis_at_nc5.infi.net) wrote:
>: > A user in one locality queries multiple locality's databases.
>: This causes our system to join tables/views across multiple servers.
>: These queries take anywhere from 5 - 20 minutes, hence our
>: problem.
>
>
>T1 lines run at 10% of the speed of current Ethernet lines. When
>connecting multiple databases, throughput could be slowed by geometric
>proportions.

Make sure that you drive the query from the correct end. The local optimiser will know little or nothing about the remote views and will drive the query from the local database - often using a full table scan. Try splitting the query into two cursors, with the cursor for the remote query controlling the loop for the inner cursor.

Cheers,

Graham

(P.S. I am not responding formally for my company) Received on Wed Sep 13 1995 - 00:00:00 CEST