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

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.