Francisco H Tapia
my.lists at verizon.net
Tue Feb 4 13:32:01 CST 2003
I agree with Martin, If you are using an ODBC connection from Access to Informix, then you ought to be able to connect directly from SQL, one thing you didn't mention is if you are using a DTS package in order to transport your data from Access to SQL, my current process does not have so many records but the source DB is 250megs, and I normalize the data on the fly it takes less than 30minutes... -Francisco http://rcm.netfirms.com ----- Original Message ----- From: <Mwp.Reid at Queens-Belfast.AC.UK> To: <accessd at databaseadvisors.com> Sent: Tuesday, February 04, 2003 11:18 AM Subject: Re: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!: : : Ron : : excuse my ignorance of Informix but why do you need Access to sit in the : middle? : : Martin : : : : : Quoting Ron Moore <rmoore at comtechpst.com>: : : > *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 :