Implementing Multithreading In A Client Server Architecture
We have a client server application which deals with lot of data manipulation using stored procedures on the Server ( 8 GB RAM and 450 GB Hard Disk). Our client is developed in .Net 2003 (1 GB ram, 80 GB Harddisk)
I would like to know that in this scenario how can we implement Mutithreading? Will it be helpful in improvising the performance of the application with respect to processor utilisation, can we re-direct commands ( in our case Stored Procedures ) to different processors on servers.