That's a tough one to answer without knowing more about the tables that you
are querying against, the query itself and the machines you are hitting.
In general, I haven't seen great performance when doing joins via dblinks,
so my knee-jerk reaction is to "dial direct and save." If you are going to
do this, I'd open separate connections using multiple dbhandles, rather
than re-using the same one.
The short answer is to try both approaches and benchmark them on your
system and see which one runs faster.
jeff
*******************************
Jeff Seger
Data Warehouse Engineer
Fairchild Semiconductor
[EMAIL PROTECTED]
*******************************
rajib.n.mukherjee@v
erizon.com To: [EMAIL PROTECTED]
cc:
04/30/2002 09:19 AM Subject: individual connections over
dblink
hi all,
for a certain application of mine i need to connect to three diff databases
to print the content of a single line thru CGI
i have two options
1. individually connect to each database. and drop connections
or
2. connect to one database and use the dblinks from there
the application is sitting on a machine that has a resource crunch.
will my 2nd approach help to lessen the burden on the server ????
appreciate responses
rajib
