Barely any CPU used for ASP.NET/MySQL application
Posted on 2008-10-19
I'm building an import utility for ASP.NET and MySQL. It imports contacts from a CSV or XLS file. The problem is my local dev machine (Windows 2K3, IIS 6, Celeron 1.8 ghz single core) imports contacts about 10 times faster than our server (Windows 2K8, IIS 7, 8-core intel xeon). I've noticed that when running this import on the server, it doesn't even use 1% of the processor, while my dev machine uses a lot more.
This import tool is pretty intense and a lot is going on with it. Is there some sort of processor cap that I can modify? I obviously don't want it using all 8 cores at once, but it doesn't even crack 1% cpu usage during the import operation and as a result is causing import operations to take incredibly long to complete.
Any ideas? Thanks.