We have developed an ASP.NET web interface for our product. We're using MySQL v3.50.13. The main web page uses an ASP.NET GridView with custom paging implemented. Each load of the page opens a connection to the database, queries the data and closes the connection.
When one user is accessing the web page there's no problem but when more than one user starts using it both user's pages become unresponsive and never loads.
In looking at the server the aspnet_wp.exe is taking 60-80% of the CPU. At first I was thinking that it was an ASP.NET / IIS problem but now I'm thinking it could be something related to the way I'm using the Core Lab MySQL objects.
I've read stuff about connection pooling but the bottom line is that I don't know what the problem is.
Any help would be greatly appreciated.