SQL query times
Posted 10 February 2006 - 10:32 AM
Posted 11 February 2006 - 04:36 PM
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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users