How to make the process quicker?
Posted
by dewacorp.alliances
on Stack Overflow
See other posts from Stack Overflow
or by dewacorp.alliances
Published on 2010-03-09T00:27:32Z
Indexed on
2010/03/09
0:36 UTC
Read the original article
Hit count: 280
sql-server-2005
We build a system that handling the billing analyse and what it does it just have a raw bill from vendor and process to "common" table and this is using SQL Server 2005 Integration Services.
At the moment, the batch has 300,000 rows and it took about 6 minutes to process. Now, the current spec are: 2 CPUs Intel Xeon E5345 @ 2.33 GHz RAM 4GB
Is there anyway I can speed up this process?
© Stack Overflow or respective owner
