Q

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.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

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 first published in July 2002

Dig deeper on Web Development

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close