Re: ODBC connection speed

[Jeff Silberberg <jsilberberg@xxxxxxxxxxxxxx>]

Paul,

        Not enough to be sure here, but it sounds like the old here or 
there issue.  A query from MSACCESS for example will pull a file locally 
before doing the WHERE
clause try making the QUERY a "Pass Through" and let it run on the iSeries, 
the same as you are running the data on the SQL ms-server.  This way you 
only return the result set, not the whole table.  This by the way is not an 
iSeries thing it would do the same with a ODBC to Oracle or SYBASE for 
example.

        JMS...

At 08:14 AM 3/17/2003 -0600, you wrote:
> I have a client who does a lot of his reporting via ODBC connections (M$ 
> bigot). When he creates a flat file and sends it to his SQL server, his 
> queries run very quickly. The same query definition, however, run thru 
> ODBC takes as much as 3 times as long. I'm waiting for him to send me an 
> example of the query statements so that I can examine them for the obvious 
> culprits, but can anybody think of anything else?
>
> Paul Nelson
> Arbor Solutions, Inc.
> 708-670-6978 Cell
> 708-923-7354 Home
> pnelson@xxxxxxxxxx
> _______________________________________________
> 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.

Jeffrey Silberberg
CompuDesigns, Inc.
Atlanta, GA. 30350
(770) 399-9464