Unanswered: probelm in retrieving data in powerbuilder when connecting to db2/400 through ODBC
I have a problem while retrieving data from powerbuilder ISQL when connecting to db2/400 through ODBC connection.
The problem is the large consumed time when retrieving data from any table specially when the table has alot of columns
(e.g. Retrieving from table that has 100 columns and 17000 records cost me exactly 2 minutes)
Is there any pre-configurations in db2/400, ODBC, or powerbuilder to improve this performance????????
Please send me all the possible causes and possible solutions.
please contact me ASAP.
Thanks for consideration.
1 - Version : PowerBuilder7 with last updates
2 - Connection String :
// Profile eastern_db
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=eastern_db;UID=rada;PWD=ra da'"
3 - The Performance when using access is very different from powerbuilder
as you see in the sent example, when using MS Access the time is only
1 (only one ) second.But when using VB it spent time about 2 minutes.
4 - The version of ODBC is the same on both client and server Client Access5
1 - I have tried to use another versions of powerbuilder but the result is still
2 - I have tried to change on some of the ODBC DSN options but the result
also still the same.
3 - The ODBC DSN options that I tried to change are : -
* Enable or Disable Pattern Search CheckBox
* Enable or Disable Extended Dynamic (Packages) Support.
* Change The Record Blocking Size.
* Enable OR Disable DataCompression.
4 - I have read alot of documents that help in improving performance but
there is no actual improvement.
5 - There is no differenece in consumed time when running a SQL statement
from PowerBuilder ISQL or from retrieveng through DW in RunTime.
6 - Some times The performance when using VB is worse than using
7 - The client configuration is very perfect with large Physical memory size.