futureDBA
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
figured it out, thanks
please check what is your bandwidth.