Current Import speed

jsynoski · Post by **jsynoski** » Wed Apr 14, 2004 2:52 pm

I know from previous posts/mailing list topics that imports under V1 could be glacial and I thought that speeding up this process was one of the goals of V2. I have yet to see any posts about the speed changes, so how have you done?

Any idea on how long a 1.6G, 26,000 files SourceSafe\data directory with few labels should take to import?

Jim Synoski

Post by **jeremy_sg** » Wed Apr 14, 2004 3:06 pm

It very much depends on the structure of your database., so I really can't estimate how much time it will take. Are you asking this because you have an import that's taking a long time, or because you want to know ahead of time?

jsynoski · Post by **jsynoski** » Wed Apr 14, 2004 3:10 pm

Ahead of time. I'm going to tell our IT guy that this needs to be a weekend job, but it would be nice to have some confidence that only a weekend is needed.

JackTripper · Post by **JackTripper** » Sat Jul 03, 2004 6:19 am

i started my import of our 2GB database 15 hours ago.

As of right now it's a little over half (23/38ths) done the pre-scan.

Assuming the actual import is just as slow, i estimate it will take 50 hours.

(15hours) / (23/38) * 2passes = 49.5hours

JackTripper · Post by **JackTripper** » Sat Jul 03, 2004 6:21 am

Bugger. That's not supposed to be a smilely, but a 38 and a right parenthesis

Post by **jeremy_sg** » Sat Jul 03, 2004 9:05 am

I only have bad news. The actual import stage takes much longer than the prescan. Do you have lots of shared items?