G
Guest
This may not be the proper forum to ask this question, but I am totally stuck
on something that I need someone elses input on.
I just migrated my Access app to SQL Server 2005 and have found the the
learning curve for the SQL 2005 DTS Equivilant is steep and something I don't
have time for right now. Plus, I do not have access to SQL 2000 to do DTS.
Anyway, I am handling my data conversion using Stored Procedure and Code.
Here is my question.
I have a table "tblTableName" that has 20 fields that should have been
normalized in the first place. (i.e. 1 lookup table). These fields are named
"Oper1, Oper2, Oper3, Oper4..." for a total of 20. I've changed this to
OperID and now have a lookup table called tblOper. During my data conversion
I am checking the value of Oper1 against the tblOper table to retrieve the
OperID value. If it exists, I return it, otherwise I add the Oper1 value and
return the new OperID.
The problem I have it is this is very process intensive. In my example, the
table has 26,000 records. Not very big. But, because of all the processes
that are occuring it takes 7.2 hours to convert one table based on my
calculations. Needless to say, I need to find a method that will insert the
records faster. ANY SUGGESTIONS. (SORRY TO THE CAPS, MY KEYBOARD JUST GOT
STUCK IN ALLCAPS).
on something that I need someone elses input on.
I just migrated my Access app to SQL Server 2005 and have found the the
learning curve for the SQL 2005 DTS Equivilant is steep and something I don't
have time for right now. Plus, I do not have access to SQL 2000 to do DTS.
Anyway, I am handling my data conversion using Stored Procedure and Code.
Here is my question.
I have a table "tblTableName" that has 20 fields that should have been
normalized in the first place. (i.e. 1 lookup table). These fields are named
"Oper1, Oper2, Oper3, Oper4..." for a total of 20. I've changed this to
OperID and now have a lookup table called tblOper. During my data conversion
I am checking the value of Oper1 against the tblOper table to retrieve the
OperID value. If it exists, I return it, otherwise I add the Oper1 value and
return the new OperID.
The problem I have it is this is very process intensive. In my example, the
table has 26,000 records. Not very big. But, because of all the processes
that are occuring it takes 7.2 hours to convert one table based on my
calculations. Needless to say, I need to find a method that will insert the
records faster. ANY SUGGESTIONS. (SORRY TO THE CAPS, MY KEYBOARD JUST GOT
STUCK IN ALLCAPS).