General information
Category:
Coding, syntax & commands
>>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?
>
>if this is a one-time deal, i'd import to a table wo/ the RI and functions. if it isn't, i'd be patient.
>
>btw, i'm not familiar with the newid stored procedure. is this a default value for a field in a new record?
I am NOT using RI, but simply a stored procedure that gets
the next sequential unique id for a table from a table named sysids.
I can not do a simple APPEND from the text files since I do not
need all the data and need to modify some of the data as well.
Previous
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