MSP98, ODBC and Oracle

From: Bernard Stevens <bstevens_at_club-internet.fr>
Date: Wed, 18 Aug 1999 03:20:38 +0200
Message-ID: <37BA0A66.EDEE97B7@club-internet.fr>

Hello all,

I am using an Oracle database to store multiple MSP98 projects through the File Load/Save functions and ODBC.

They work OK but ODBC is very slow.
Analysis of the Oracle trace files during Load/Save shows that numerous parsing requests are sent to Oracle besides the effective I/O operations.

It looks like every single column reference is checked against the Oracle catalog prior to issuing the actual SELECT / INSERT / UPDATE statement.
Clearly, extremely ineficient.

Does anyone have ideas ?

Configuration is : MSP98 SR1, Oracle 7.3.2, MS ODBC for Oracle 2.573

Thanks. Received on Tue Aug 17 1999 - 20:20:38 CDT