asked on
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?
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 DatabaseMySQL Server
Last Comment
futureDBA
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
my execution times are pretty fast, i am doing this from the same machine that I have sql developer on
ASKER CERTIFIED SOLUTION
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.
ASKER
figured it out, thanks
please check what is your bandwidth.