Improving performance of SqlConnect against ORACLE

Discussions specific to Team Developer 5.1.

Improving performance of SqlConnect against ORACLE

Postby jmgemperle » Wed Jul 01, 2009 7:45 pm

If you experience performance issues with SqlConnect() in connecting to ORACLE using the native router.
And your SQL.INI [oragtwy] section of your remotedbname is configured the following way ie


please change it to not use the TNS part as bellow


This is enough to connect and this should fix CONNECTION performance issue you might have noticed with ORACLE.
User avatar
Posts: 886
Joined: Thu Feb 15, 2007 1:57 am
Location: Leiden The Netherlands

Re: Improving performance of SqlConnect against ORACLE

Postby SteveLeighton » Mon Jul 06, 2009 6:00 am

Nice tip - I'm going to check this out forthwith. Specifically which version of Oracle ? (TNSNames.Ora) are you using ?

May I post your tip on the Team Developer Tips & Tricks Wiki ?
Best wishes
Bankside Systems Ltd. ( New Zealand )
Go forward! Come join the TD, SqlBase & TDMobile community on
Team Developer Community Forum
User avatar
Posts: 114
Joined: Tue Jan 15, 2008 7:50 am
Location: Tauranga, New Zealand

Return to Team Developer 5.1

Who is online

Users browsing this forum: No registered users and 1 guest