Ron Moore
rmoore at comtechpst.com
Tue Feb 4 13:43:00 CST 2003
Martin, Informix is a 'post-pick', multi-value DB that uses a character delimiter to nest data (much different than the usual relational DBs out there!). Our DG box for Informix is on the low side of 'low-end' so I cannot get a ODBC driver to function properly. Net result ==> a CLOSED DB. So I extract the data to text, pull from txt or xls files into A2K, manipulate against a manually entered record in SQL app, and push the resulting record set over. Hope that's a little clearer, Ron -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mwp.Reid at Queens-Belfast.AC.UK Sent: Tuesday, February 04, 2003 2:19 PM To: accessd at databaseadvisors.com 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