General information
Category:
Coding, syntax & commands
Title:
Adding Mass Amounts of Data?
I have a project where I need to load in a few million
text files to one of two tables. I am using a primary
key that is assigned via a stored procedure routine
similar to the one used in TasTrade (newid()).
The first file contains 1.2 million records and after
22 hours it is only about 1/2 complete.
Would it have been better to not set NEWID() as
the default value and used a different technique?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only