RE: database links and performance

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 8 Feb 2005 09:49:05 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A97316@exchsen0a1ma>

John,

I use them in a couple of applications and generally, they work fine. A slow network is a slow network. Yes, it can hurt performance. If you think that your network cannot support your application, then find another way to do it.

A couple of tricks to consider:

If you need to join tables in the remote computer, consider creating a view in that computer and calling that view from your local machine. It will perform much better - basically, limit the joins from remote tables - bad things happen.

Good Luck.

Tom

-----Original Message-----

From: John Dunn [mailto:jdunn_at_sefas.com] Sent: Tuesday, February 08, 2005 9:40 AM To: Oracle-L_at_freelists.org
Subject: database links and performance

We are considering using database links in Oracle 9i but are concerned about performance.

Presumably the network can be a bottleneck when using database links.

Does anyone have any useful experiences with performance of database links?

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 08 2005 - 09:58:48 CST