Re: ODBC connection speed

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Some links:

<http://www-1.ibm.com/servers/eserver/iseries/db2/queryblues.htm>
<http://www-1.ibm.com/servers/eserver/iseries/db2/dbcomp.htm>

Then look at the ODBC driver settings, esp. the Advanced settings. Things 
like increasing the size of record blocking will help. Look at the help for 
each option - click on the "?" in the upper right of the window, then click 
on the option.

HTH

Vern

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