troubleshooting Question

dg4odbc vs dg4msql

Avatar of futureDBA
futureDBA asked on
Oracle DatabaseMySQL Server
4 Comments1 Solution1618 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros