[AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:

Will ask one of our DBAs. If it goes on a server one of them will have used it.

Martin


Quoting Ron Moore <rmoore at comtechpst.com>:

> 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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>