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).
Dig deeper on Web Development
Related Q&A from Jim Mason
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better...continue reading
There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.