|
Slow performance is almost always not an ODBC driver issue but an SQL issue. That is the SQL you requested will probably run as bad on iSeries local session.
Why? It is possible that the request is selecting rows based on non-indexed selection columns, it is also possible that it must create an index to perform join.
You need to troubleshoot the SQL performance.
Click here for an example.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
|
