Ron Moore
rmoore at comtechpst.com
Tue Feb 4 14:45:00 CST 2003
Martin, Been down that road too many times! I've fully explored the use of multi-value ODBC drivers for Informix. They work very well on other platforms. We're stuck with a low-end server! I had hoped to make our legacy systems an open DB, to no avail. In the interim, I've created various 'utilities' that captures screen display and dump txt and launch MS apps, use code to format, chart, etc. Informix is a great DB environment, just not for us. If we are upgrading the server, why not upgrade the app (says upper management) Thanks Again, 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 3:21 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!: This is a shot in the dark as I know nothing about the source db. Is it possible that you are pulling out more than the tables for example catalogs or other descriptive data. The OLEDB Provider and DTS is supposed to work well but I have as I said no direct experience of it. Martin Quoting Gustav Brock <gustav at cactus.dk>: > Hi Ron > > > Hi Gustav, No, I haven't tried, and I'm still learning the new, > mostly > > undocumented, schema of the new app. Do you think the indexes account > for a > > large chunk of the five hours? Being new to SQL, would I have to > manually > > record and recreate the indexes, or can I store the index 'defs' > > temporarily? > > Sorry, I'm not an expert on SQL Server, so I can't give you any smart > tips. > The index dropping/recreation is a general tip when appending large > amounts of (known or otherwise validated) records to a large table. > > /gustav > > > > Have you tried dropping the indexes on the target table during the > > appending? > > Of course, recreate them afterwards. > > _______________________________________________ > 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