How to make the process quicker?
- by dewacorp.alliances
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?