Performance problem?
From: mikeb (mikeb_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: Rob Sutton: "Re: Linked server to as400 - for the love of god please help."
- Previous message: Rodger: "Re: Database Restore on a Linked Server"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Performance problem?"
- Reply: Mike Epprecht (SQL MVP): "RE: Performance problem?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 09:47:07 -0700
I'm having performance problems in the following scenario:
I import about 3 million rows into a table with DTS(no indexes because of
the large amount of data). I then run a script with 3 delete and about 25
update stmnts. This takes about 3 hours( Is that long?), I then Truncate the
table and recreate this process(with new data ofcourse). It takes longer and
longer on each iteration. What can i do to improve the performance? Would
dropping and recreating the table or the actual DB help? I've noticed that
the time I save running this script with an index during the import is offset
, since it takes much longer to import that much data with an index. Any
ideas would be greatly appreciated! Thanks!
Also, recovery is set to SIMPLE!
- Next message: Rob Sutton: "Re: Linked server to as400 - for the love of god please help."
- Previous message: Rodger: "Re: Database Restore on a Linked Server"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Performance problem?"
- Reply: Mike Epprecht (SQL MVP): "RE: Performance problem?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
