I've written a C# ASP.Net 3.5 Web Application that uses Microsoft Ajax and a SQL Server 2005 database. It uses an ObjectDataSource and does the paging in a stored procedure.
From clicking a button to showing the populated gridview with the 1st 25 records in the table takes around 1 second on my local pc, but around 7 seconds on a shared server hosting account.
The host has a seperate dedicated SQL Server 2005 box (shared with around 100 users) so I've tried running the underlying query in my local copy of SQL Server Management Studio Express connected to the remote database and it takes less than a second to run the same query. So it doesn't look like the database is at fault.
When serving pages without any processing it appears within a second, so it doesn't seem to just be a case of a slow host.
Is there anything I should try changing in the web config that could speed it up?
Allowing 1 second to run the query and 1 second to send the data over the wire, 5 seconds seems a long time to be processing.
I only have 4.5% share of the CPU and I'm not sure how much Ram, so perhaps it just doesn't have enough resources to run quickly.
If I do need to go for a dedicated server, should SQL Server 2005 Express run ok on a server and give good performance with moderate traffic?
Start Free Trial
