The drivers are not at issue, they just pass the query over to the actual DB and get results back. MS SQL Server and it's linked servers are not acting quite like a regular client using a driver. MS SQL Server being a RDBMS itself has it's own SQL syntax and query processor. It naturally assumes that you want the local query engine in SQL to respond to you request, so it rewrites your query that it sends over the driver to pull in all the records so that it can handle the processing. This allows you to do MS SQL syntax things that you may not be able to do with your native DB. Generally, we don't really want that so instead we use the openquery() MS SQL function to force the query to be executed on the native DB server. As someone mentioned earlier, it essentially tells MS SQL to sit on it's hands and just receive data.
Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Thursday, July 09, 2015 12:09
To: Midrange Systems Technical Discussion
Subject: RE: [Bulk] RE: Speeding up ODBC
Importance: Low
I assumed the issue was in the driver rather than the client, but that's just a WAG.
-----Original Message-----
From: Mark S Waterbury [mailto:mark.s.waterbury@xxxxxxxxxxxxx]
Sent: Thursday, July 09, 2015 1:36 PM
To: Midrange Systems Technical Discussion
Subject: Re: [Bulk] RE: Speeding up ODBC
Is Squirrel "open source"? Perhaps someone can have a look at the source code to figure out what they are doing "differently" to avoid such performance issues?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
---------------------------------------------------------------------
This electronic mail message and any attachments may contain confidential or privileged information and is intended for use solely by the above-referenced recipient. Any review, copying, printing, disclosure, distribution, or other use by any other person or entity is strictly prohibited under applicable law. If you are not the named recipient, or believe you have received this message in error, please immediately notify the sender by replying to this message and delete the copy you received
---------------------------------------------------------------------
midrange.com
