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