From Access To Informix 1

[rgbanse]

I have moved a table from Access97 to Informix.
Schema is identical as well as indices.
Using ODBC to get data is "Painfully" slower.
Any thoughts
thx
RGB

 

[vpshriyan]

Hi,

Is the data retrieval at the backend without using ODBC is slower too?
If Yes,
1. Perform update statistics for the table.
2. If a where clause is regular feature in the select & an index is not heading on such column(s) it is better to introduce one.
3. If the select involves 3 or more joined tables, set the optimization to low & benchmark the performance.
4. If you have multi-processor enabled server, try assigning PDQ memory pushup. set pdqpriority 10; select ...
If above steps helps in performance boost, thus may prove productive to ODBC retrieval too.

If Not,
1. Use ping and tracert utility, and analyse network timings and hops.
2. Trace for network blocks / chock ups / collisions (if any).
3. If you rely more on ODBC connections, plan to increase the parameters related to NETTYPE onconfig parameter.

Regards,
Shriyan

"Life is a test, if this had been a real life you would have been given instructions on where to go."