RE: Speeding up ODBC

Seen these periodically over the years sometimes with ODBC and JDBC and ADO.Net.

Even though the correct index exists it doesn't get selected when using the DB drivers over interactive.

Try the query in iSeries Navigator and see what happens.

If it's DB driver related you might then be able to reach out to IBM.

Not sure what you mean by telling ODBC to do the bulk of the processing on I ? I believe it does.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx
www.rjssoftware.com
Visit me on: Twitter | LinkedIn

------------------------------

message: 6
date: Thu, 9 Jul 2015 11:30:52 -0400
from: rob@xxxxxxxxx
subject: Speeding up ODBC

I know this comes up on the list a lot, and forgive me for not searching,
but the dilemma is something like this:
You run this sql statement that does a select with ordering, where's,
grouping, etc and it takes forever in ODBC but runs pretty fast from
STRSQL.
How do I tell ODBC to do a bulk of the processing on the IBM i?


Rob Berendt