performance issue

[Francois Houde]

we have migrated an application from Acces 97 to Access 2000. The
application is very simple it read data from an AS/400 database and fills the
local table with it. on windows 95 + Access 97 it takes about 30 seconds to
do the job. With Access 2000 we stopped the job after 2.5 hours.

We tought the ODBC was the problem but it's not since we have other
application that uses this ODBC and they all work great.

If you have any ideas on how to solve this issue, i'll be glad to hear them.

Thanks

 

[Chris Mills]

We tought the ODBC was the problem but it's not

copy-down some tables from ODBC to local. Now tell me if that's the problem?

(I don't know why the ODBC is so slow, however. Your other apps appear not to
be A2000, and A2000 is well-known to be a dog. Why not stick to A97 which you
were happy with?)

My limited experience with ODBC (not AS/400), was that it was so abysmal that
it was faster to download tables and then do stuff with them. Even in A97.

Chris