[Driest]

I have an VB.NET web app which performs a fairly complicated SQL query. It seems in the morning, the 1st time the page is loaded (and query executed) it takes up to 10-15 seconds to complete loading. Sometimes it even times out. However anytime after that, the page loads up (even from another computer) in about 4-5 seconds. Can someone explain the reason for this and how I might fix the load times in the morning?

Thanks

[Advertisements]

Hi Driest,

the load on the server is the most likely culprit for the slower page loading - more users in the morning than later in the day.

are you able to modify the vb.net code?
the query is run from the index page on startup, right?

if so to both , then you might consider creating 2 test pages - one with the query and the other with the remaining index page. run each page during a peak period and time each. if the query is using the most time, then there's not you can do unless you simplify the query(which you most likely don't want to do). if the rest of the index page is the slow component, the try removing images or other slowly loading components.

bdlt

[bdlt]

Hi Driest,

the load on the server is the most likely culprit for the slower page loading - more users in the morning than later in the day.

are you able to modify the vb.net code?
the query is run from the index page on startup, right?

if so to both , then you might consider creating 2 test pages - one with the query and the other with the remaining index page. run each page during a peak period and time each. if the query is using the most time, then there's not you can do unless you simplify the query(which you most likely don't want to do). if the rest of the index page is the slow component, the try removing images or other slowly loading components.

bdlt