RE: database links and performance
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'jdunn@xxxxxxxxx'" <jdunn@xxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 8 Feb 2005 09:49:05 -0500
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@xxxxxxxxx]
Sent: Tuesday, February 08, 2005 9:40 AM
To: Oracle-L@xxxxxxxxxxxxx
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?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
