Possible reason for Visual LANSA Imports running slowly

Date: 1 September 2003
Product/Release: Visual LANSA
Abstract: Imports running very slowly for Visual LANSA
Submitted By: LANSA Technical Support
Last Review: November 2010

Any imports into the Visual LANSA environment seem to run very slowly, sometimes taking hours. This slow imports issue can appear during standard Visual LANSA *limports or after performing an installation or upgrade of Visual LANSA, when the imports that are a part of the installation are run.

Possible Reason:

Check if ODBC tracing is enabled, thus slowing the imports. If tracing is enabled, this can add enormously to the time to perform an import. Disable the ODBC tracing and perform the import again. The screens below show ODBC tracing enabled and disabled.

Tracing enabled:

Example screen showing tracing enabled

Tracing disabled:

Example screen showing tracing disabled