Information générale
Catégorie:
Codage, syntaxe et commandes
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement