Problem solve Get help with specific problems with your technologies, process and projects.

Optimize queries in Client Access

We are accessing data from the iSeries to an NT server via the Client Access ODBC driver using Active Server Pages....

We continually try to optimize queries to make sure they are selecting logical files to speed up processing time. However, we were wondering if there is a faster ODBC driver to use between Win2k and the iSeries. We know there are third-party products. We've tried Hit - but it was actually slower than the ODBC driver provided by Client Access. Is there a faster ODBC driver than Client Access that you would recommend? If you're committed to ASP, we don't know of a faster one.. sorry. On the other hand, designing high speed, high volume applications works well in Java. You can create multiple threads executing concurrently, each accessing data quickly using JDBC dynamic prepared statements or static SQL. Obviously you need to clearly identify WHERE the performance problem is. If 90% of the delay is on the iSeries in database access (vs. transfer using ODBC), then you need to simplify the data access better with indexes, logical views, perhaps a read-only data mart concept.

Also, Java has the advantage of being able to process data on the iSeries or a PC. If processing on the iSeries, you could send the "net" results, not all the data, to the PC, improving performance. Many options exist for this : applet to servlet, application to servlet, etc. RMI can do this also but is probably not your fastest option.


Ask your Web development questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: tips, tutorials and more.

Check out this live Q&A with Dave Slater and Jim Mason, How to best get started with WebSphere Development Tools.

Search400's targeted search engine: Get relevant information on machine interface (MI).

This was last published in July 2002

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.