SQL to SQL

[LuisRivera]

I am trying to transfer some data from one sql table to another using an ASP page to process the information.

I created the page which simply opens the source table and extracts the records (7550) into a recordset and then the page creates an SQL Insert query to output the records one by one via a do while loop.

This process works fine until it gets to about 1500 records imported and then the process starts to slow down dramatically until it is processing one records every ten minutes or so (i think the process would slow down even more if i had the patience to let it go)

I think the problem lies with my SQL server configuration but i am not sure how.

Any ideas.

[qball]

I am trying to transfer some data from one sql table to another...


Why process each single row, unless you need to manipulate the data (ETL). Do it with SQL, not with ASP.

INSERT INTO tbl2
VALUES (SELECT cols FROM tbl1 WHERE clause);

Dependent upon DBMS, you may need to tweak syntax.