Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

SQL query times


  • Please log in to reply

#1
Driest

Driest

    New Member

  • Member
  • Pip
  • 7 posts
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
  • 0

Advertisements


#2
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
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
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP