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

John Bartow john at winhaven.net
Tue Feb 4 13:50:01 CST 2003


Are Informix and SQL server both going to be part of the final soulution
with migration between the two being a regular process or is the goal to
eliminate Informix?

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Ron Moore
Sent: Tuesday, February 04, 2003 1:08 PM
To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com
Subject: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:


*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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list