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

Thanks Gustav (and everyone else who answered),

I will attempt to drop the triggers and run a fresh build tomorrow.  I
suppose I need to keep the triggers and constraints for validation though.

Thanks Again,
Ron

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Tuesday, February 04, 2003 3:09 PM
To: Ron Moore
Subject: Re: [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.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com