About
Pricing
Community
Teams
Start Free Trial
Log in
futureDBA
asked on
12/24/2012
dg4odbc vs dg4msql
I was using a direct database link to an mssql using dg4odbc..
because of performance issues i started looking for alternatives and installed transparent gateway with dg4msql
performance is unchanged. there is no difference in querying time
eg
select * from rmordp@"dblink" where ORDITMNUM = 89129 and ordordqty = 48 and ordseqnum = 24 and ordprcgrp = 8242;
takes 9.351 seconds over the database link.
if i run that same query from the mssql server, it takes less than half a second..
can someone tell me what I am doing wrong or how i should go about getting remote data via oracle in a timely fashion?
Oracle Database
MySQL Server
4
1
Last Comment
futureDBA
8/22/2022 - Mon
Praveen Kumar Chandrashekatr
12/24/2012
when you are querying remotely it also depends on the network bandwidth which you have to communicate between the servers.
please check what is your bandwidth.
futureDBA
12/24/2012
ASKER
its not a bandwidth issue, when i use TOAD for SQL Server to query the sql server directly (without having oracle as a middle man)
my execution times are pretty fast, i am doing this from the same machine that I have sql developer on
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)
12/26/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
futureDBA
1/8/2013
ASKER
figured it out, thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
please check what is your bandwidth.