Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › homepage loading very slow on first visit

homepage loading very slow on first visit

Thread began 5/25/2012 7:23 am by Christopher West | Last modified 5/29/2012 8:56 am by Christopher West | 1822 views | 4 replies

5/25/2012 9:17 amJason ByrnesWebAssist

one issue is see is that you are using 4 recordsets to pull the featured images, why not just use one and add an OR condition to the where clause:

WHERE FeatureCategoryType = 'Homepage1' OR FeatureCategoryType = 'Homepage2' OR FeatureCategoryType = 'Homepage3' OR FeatureCategoryType = 'Homepage4'

also in the feature table, try adding an index to the feature.FeatureProductID column and the FeatureCategoryType column, that may help speed up the queries.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.