slow data loads 1

[rtgordon]

My data loading has really begun to bog. I know that part of the reason is the cursor that I am using to load the data. After researching, I realized that I had misunderstood the fill factor for indexes. I was thinking that a fill factor of 70 meant 70% additional free space. I guess that it means 70% filled, which is not what I want. My research also made me wonder... The fact that I have a clustered index on the part number makes it worse.

Should I just get rid of the clustered indexes while I am loading 50,000 parts a day into my database? Or should I just set the fill factor way down to something like 25?

gordon

 

[MAK9974]

Drop the clustered index and load the data and recreate the clustered index after that.

Use forward readonly /static cursor to speed up.

 

[rtgordon]

Thanks! I'll try it as soon as my slow load finishes running.

I suppose that you mean something like

declare DataCursor cursor forward readonly static for...

 

[MAK9974]

u r right