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

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Tue Feb 4 14:22:01 CST 2003


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
> 



More information about the AccessD mailing list