close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

homepage loading very slow on first visit

Thread began 5/25/2012 10:23 am by Christopher West | Last modified 5/29/2012 11:56 am by Jason Byrnes | 850 views | 4 replies |

Christopher WestCommunity Expert

homepage loading very slow on first visit

if i cleared my cache or access website on a different computer the homepage takes ages to load (well the main image on the right (which is just static image small filesize etc) but mainly the 12 images (thumbnails) below that take ages to load on a first visit to the homepage) those thumbnails are pulling froma database - if i showed you my code could you possible detect why this is so slow?

Chris

Attached Files
index.zip
Sign in to reply to this post

Steve

I ran Firebug on the page (your live one) and saw but one small css issue that should not have created the slowdown you are experiencing.

www.dinkyfingerprint.co.uk/

Expected end of value but found 'font-weight'. Error in parsing value for 'letter-spacing'. Declaration dropped.

letter-spacing: 0px font-weight: normal;

template.css (line 61, col 34)



Maybe someone else will be able to determine the reason for the slowdown.

Sign in to reply to this post

Jason 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.

Sign in to reply to this post

Christopher WestCommunity Expert

Jason, if I create 1 recordset as you suggested how can i code it so that in i can reference records 1 to 3 in one part of the page, 4 to 6 in another part of page, 7 to 9 in another and lastly records 10 to 12 in another area on the page. as the whole idea is to have 4 sections on the page displays highlighted featured products. the method i had used was just a simple recordset loop to showing 3 at a time (hence why i used 4 recordsets to achieve this) as i dont know how to manipulate certain records at a time.

Chris

Sign in to reply to this post

Jason ByrnesWebAssist

use the mysql-data-seek() function to change the result pointer location
function.mysql-data-seek.php

to show the first record:

php:
<?php mysql_data_seek($rsFeature0); $row_rsFeature mysql_fetch_assoc($rsFeature); ?>




to show the second:

php:
<?php mysql_data_seek($rsFeature1); $row_rsFeature mysql_fetch_assoc($rsFeature); ?>



and so forth.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...