June 1, 2006 at 1:39 am
You might try truncating the table instead of deleting. This could (I stress could, because I'm not 100% sure) give you a pointer as to whether the reload is running into a problem with logs.
Is it perhaps a big file which is inserting row by row rather than by bulk insert, and hence writing a log for each insert? Delete From will also log the deletes - so perhaps your logs are growing too much. Not sure why a reboot would be helping so perhaps I'm spouting nonsense.
However, the principles hold - if youhave a big file to upload, try a bulk insert, and if you have a whole table with lots of data to delete and don't care about rollback, identity reseeding etc, use Truncate Table rather than Delete From.
June 1, 2006 at 3:27 am
Hi,
How are u uploading the data from file.
HTH
Killer
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply