Last post Jul 19, 2013 02:04 AM by kctt
Jul 08, 2013 05:10 PM|Stark8352|LINK
I'm looking for some help/guidance relating to an issue with the deployment of my website to a shared hosting service. I've been testing my website on my local machine using visual web developer and the SQL express server that ships with it. My website
involves several (approx 15 - 20) queries of the database on any given page to display various statistics, table data, graphs etc to the end user. Now all of this works nicely on my development machine in terms of speed of queries but the moment I upload
it to the production server, those queries can take up to 4 or 5 seconds before the page is updated. This is not exactly what I had in mind for the user.
I'm struggling to understand where the problem might lie. Could it be through bad coding/queries on my part, the shared hosting environment (although they tell me its not that) or is it the sheer volume of server side queries I'm executing from the database
(and the data behind it which is several thousand rows of data)? I appreciate that I'm working with a localised database as well so that's probably part of it but surely this is not a unique position I'm in, I've been on other websites where the data is updated
within a second or so.
Am I missing something, anyone have any ideas of the sorts of things I should be looking at?
Jul 08, 2013 06:48 PM|Nasser Malik|LINK
those queries can take up to 4 or 5 seconds before the page is updated
(and the data behind it which is several thousand rows of data
This time really good. Request goes to server, server process and return response to user .. I think this very good time.
Jul 09, 2013 03:26 AM|Topspy|LINK
May be because of your server location? Have you tried other service?
Jul 09, 2013 03:48 AM|Stark8352|LINK
Jul 09, 2013 03:49 AM|Stark8352|LINK
Jul 19, 2013 02:04 AM|kctt|LINK
5 seconds to load a web page is slow. It could be your hosting server is overloaded.
Ask your host for support. If loading is not improved, you should try a different host.