September 22, 2003 at 10:02 am
Hi folks! I program a Web site, www.originalyellow.com. The requirement for running queries is to have the customers' address, etc. pull up as well as their graphic ad. The boss does not want the ad to be a thumbnail.
I am using MSDE as the database engine and coding ASP for the searches. Go to the link above and do a National Search for Restaurants for the classification. You will see that the result set takes about 20 seconds to pull up. I have indexes on all the attributes that are included in queries.
Does anybody know a better way to speed up the results?
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
September 22, 2003 at 11:47 am
Have you looked at the query plan in QA? (I presume you have developer edition of SQL)
Can you pin tables in memory in MSDE? May be worth checking
Steven
September 22, 2003 at 6:27 pm
You know, you have a point there. I'm at home right now but will definitely take a look at that tomorrow. I will experiment with different fonts, borders, background, etc. Thanks for the thoughts on that!
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
September 23, 2003 at 3:09 am
Agree with Phillip. In cases like this I put time calculation displays in the page to see what is taking the longest. If you have tuned the query then it is unlikely that it is causing the delay and as Phillip says check the page build and make up. In the past I have found pages with a lot of Response.Write statements can slow page build to a crawl.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply