Solved

dg4odbc vs dg4msql

Posted on 2012-12-24
4
1,188 Views
Last Modified: 2013-01-08
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?
0
Comment
Question by:futureDBA
  • 2
4 Comments
 
LVL 12

Expert Comment

by:praveencpk
Comment Utility
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.
0
 

Author Comment

by:futureDBA
Comment Utility
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
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
I'm not a Toad user but I've seen posts that Toad buffers data.  How are you timing the Toad runs?  If it is from the first data you see, that could be the issue.  You are seeing the first few rows brought back not all of them.
0
 

Author Closing Comment

by:futureDBA
Comment Utility
figured it out, thanks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Pl/SQL Query 31 61
Export BLOB data from Oracle 10g 4 23
report returning null 21 49
ORA-12560: TNS:protocol adapter error 8 41
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now