[dba-SQLServer] What's happening here

What does the destination table look like?  How many indexes do you have?,
where is the database files physically located, if on the same channel then
you may have a throughput problem.  I would use the monitor tool and observe
what the disk I/O looks like while you're doing these loads.  It may also be
that 100K records load to ram then to disk where as 400k is too big.

On Nov 15, 2007 3:39 AM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> I am trying to copy data from a table in one db to a table in another db,
> same server.  To move 100K records takes 5 seconds.  To move 400K records
> takes 2 minutes and counting.  Why is 4 times as much data taking 30
> (PLUS!)
> times longer
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...