How can we get performance improved after getting another new application server
Currently we have one application server, and we have a windows service running on it - retrieving data from database, filling out to a DataTable, and then do some kind of caculation and update each row in DataTable, finally save changes into Database.And soon we would get another application server, what/how can we gain from this added physical resource(processor), HOW can we use multiple threads technology to improve the performance? Is there any best practices which i can follow in this case of multiple application servers?
Any comments is welcome.
--------------------编程问答-------------------- 数据量大的话,考虑使用多线程充分利用多核特性。
或者... 直接把计算移到存储过程里。
补充:.NET技术 , 分析与设计