Ron Moore
rmoore at comtechpst.com
Tue Feb 4 14:01:01 CST 2003
John, We are migrating away from Informix (not a dig against the multi-value architecture at all - I'll certainly miss some of it's strengths!). I'm developing the migration/conversion processes because they have to be repeatable (multiple piloting runs). And once we reach the go live date, I'll need the latest and greatest exports, and the legacy system is 'shut down'. Best Regards, Ron -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Bartow Sent: Tuesday, February 04, 2003 2:36 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!: 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com