[AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:

Hi Ron

Have you tried dropping the indexes on the target table during the
appending?
Of course, recreate them afterwards.

/gustav


> *cross-posted to SQL & Access Forums*

> I'm migrating/converting data from an Informix DB to a SQLServer2K app using
> A2K as the middleware.  The final append query selects records from a buffer
> table and inserts them into a SQL table through an ODBC connection.  The
> push of the largest table takes almost 5 HOURS! :-((((   The Windows Task
> Manager shows A2K and the specific DB 'toggling' between 'Running' and 'Not
> Responding', but the process does finish.

> 107,850 Records in A2K table.  72 Fields.  DB size (compressed before push)
> is 86Mb (was 346Mb).

> Do I have to live with this lack of speed?  This is for a pilot which will
> be built from 'scratch' MANY times before it goes to production.

> TIA,
> Ron Moore
> Sr. Database Administrator
> Comtech PST Corp.
> Melville,  NY
> www.comptechpst.com