Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

New Sandals website- Need Your Help please!


sandalstore

Recommended Posts

Hi Everyone,

 

We have just launched a new online sandals website and are having some major speed issues.

 

Bascially the homepage loads ok, its the inner category and product pages which take ages.

 

Try it here: http://www.sandalstore.co.uk/index.php

 

When you click on a product it takes forever to load...what do you think we have done wrong?

 

 

When you click it just seems to load up first and then the page appears instantly? We have optimised the images and kept the page small but it seems to be something else. We use broadband and have checked from different computers too. you can see a product page here: http://www.sandalstore.co.uk/talulah-toeposts-p-42.html

I would love to hear your advice and any mods or anything we could use....Thanks in advance.

Link to comment
Share on other sites

I had a quick look, there is this long delay as you say I suspect comes from the slow response of the server with respect to the database queries (the left categories box might be the prime reason). You could install a couple of different cache modules to speed it up.

 

The first one goes at the sql level. It is already part of the ultimate seo urls in your case. So this one is installed but is not utilized. You need to add wrappers for the save_cache, get_cache member functions and call them for the various sql queries from the main pages/modules. There are a couple of examples with the advanced cache module which is available separately. This module is part of the seo urls so you don't need to install it, but read the document to understand how to utilize it.

http://www.oscommerce.com/community/contributions,2873

 

The second one goes at the html level. It utilizes the browser's cache, but you need to configure it properly. The readme provides extensive instructions.

http://www.oscommerce.com/community/contributions,5029

Link to comment
Share on other sites

I don't think caching will help this one.

 

There's a serious hang going on somewhere.

 

Do you have access to my.ini? you need to log slow queries or find where it's hanging via another route.

Link to comment
Share on other sites

Hi Robert, what a co-incidence my wife was on your web site the other day ordering something?!! Shes due at the end of May and the reason we are launching this new site is to give her something to do whilst she is off work.

 

Do you know anyone who can help me fix this problem or is there any tools or anything i can use?

 

Sandalstore.

 

P>s- I like your site will put a link to it.

 

 

 

 

I don't think caching will help this one.

 

There's a serious hang going on somewhere.

 

Do you have access to my.ini? you need to log slow queries or find where it's hanging via another route.

Link to comment
Share on other sites

Thanks for your reply Enigma.

 

We will check out some of the links, but it seems like there is something major going wrong somewhere? Any advice on or tools i can use to check queries on the site or something?

 

 

 

 

I had a quick look, there is this long delay as you say I suspect comes from the slow response of the server with respect to the database queries (the left categories box might be the prime reason). You could install a couple of different cache modules to speed it up.

 

The first one goes at the sql level. It is already part of the ultimate seo urls in your case. So this one is installed but is not utilized. You need to add wrappers for the save_cache, get_cache member functions and call them for the various sql queries from the main pages/modules. There are a couple of examples with the advanced cache module which is available separately. This module is part of the seo urls so you don't need to install it, but read the document to understand how to utilize it.

http://www.oscommerce.com/community/contributions,2873

 

The second one goes at the html level. It utilizes the browser's cache, but you need to configure it properly. The readme provides extensive instructions.

http://www.oscommerce.com/community/contributions,5029

Link to comment
Share on other sites

Say thanks to your wife for using us and wish her luck from Fran and I.

 

Do you have access to my.ini firstly?

 

In plainer terms do you have root access to the server?

Link to comment
Share on other sites

Also ..

 

Do straight PHP files work ok?

 

If you upload a fresh osC to the server does THAT work ok?

 

Did the site ever seem faster? If so what mods have you done since?

 

That'll do for a start.

Link to comment
Share on other sites

Thanks for the fast reply!

 

Just like to say, you guys have an excellent website i really like it. NOt only have you developed a good design but also its well optimised for the search engines. I asked my wife what she was looking for and she typed in grow bags in google and found you! well done!!

 

 

I like the way you have articles on your site..is that a mod?

 

I will check with my programmers and hosting company about what you have asked. The site was super fast before....but then it just slowed down massively??

 

How many uniques visitors do yuo get and how long have you been running your wonderful store for?

 

SS

 

 

 

 

 

Also ..

 

Do straight PHP files work ok?

 

If you upload a fresh osC to the server does THAT work ok?

 

Did the site ever seem faster? If so what mods have you done since?

 

That'll do for a start.

Link to comment
Share on other sites

The site has been selling (first sale) in August 05.

 

Articles are information pages which I had a hand in contributing to although it has all been redone and I found it a bit buggy last time I looked at it.

 

Re: unique users

 

I don't care much for them .. just the ones who buy :P

Link to comment
Share on other sites

Thanks for your reply Enigma.

 

We will check out some of the links, but it seems like there is something major going wrong somewhere? Any advice on or tools i can use to check queries on the site or something?

if your osc admin responds (does it?) try some of the sql debug/timing modules here is one

http://www.oscommerce.com/community/contributions,4643

 

And I am sure there are others.

Link to comment
Share on other sites

Good point enigma1 didn't think of that.

 

If admin works the problem will be solely a catalog problem.

Link to comment
Share on other sites

Hi The admin section seems to work perfectly fine.

 

We have only recentaly addedd the same product into multiple categories? We have mane of these as they can be found under different names? Could this be the issue?

 

I will get my programmer to have a look at that query script?

 

Thanks for your advice.

 

SS

 

 

if your osc admin responds (does it?) try some of the sql debug/timing modules here is one

http://www.oscommerce.com/community/contributions,4643

 

And I am sure there are others.

Link to comment
Share on other sites

i have managed to install that query mod how do i know now that something is wrong??

 

http://www.sandalstore.co.uk/talulah-toeposts-p-42.html

 

 

 

Hi The admin section seems to work perfectly fine.

 

We have only recentaly addedd the same product into multiple categories? We have mane of these as they can be found under different names? Could this be the issue?

 

I will get my programmer to have a look at that query script?

 

Thanks for your advice.

 

SS

Link to comment
Share on other sites

You seem to have added the code wrong as it is showing at the top of the html, try wrapping it in <?php ?>

 

Secondly it wont do much for you as all it will tell you is how many queries were made.

 

You could try http://www.oscommerce.com/community/contri.../search,queries which I have never used but Chemo is a star so I'm sure it works.

 

The one I use for optimising is http://www.oscommerce.com/community/contributions,2575 this itemises every query, great for debugging. Also by Chemo.

 

Another thing to try after adding the right debug script for you .. is to .. one by one .. comment out the boxes in column_left/column_right and see if any make the difference.

Link to comment
Share on other sites

Hi,

 

Will get my programmer to do it for me...!

 

The query requests number does appear at the left hand side corner on the footer/ It does show some numbers when your on different pages...is that it?

 

SS

 

You seem to have added the code wrong as it is showing at the top of the html, try wrapping it in <?php ?>

 

Secondly it wont do much for you as all it will tell you is how many queries were made.

 

You could try http://www.oscommerce.com/community/contri.../search,queries which I have never used but Chemo is a star so I'm sure it works.

 

The one I use for optimising is http://www.oscommerce.com/community/contributions,2575 this itemises every query, great for debugging. Also by Chemo.

 

Another thing to try after adding the right debug script for you .. is to .. one by one .. comment out the boxes in column_left/column_right and see if any make the difference.

Link to comment
Share on other sites

Hi,

 

Will get my programmer to do it for me...!

 

The query requests number does appear at the left hand side corner on the footer/ It does show some numbers when your on different pages...is that it?

 

SS

no, these are not sql queries/timings, this is the total count of page hits by visitors.

Link to comment
Share on other sites

Ok my excellent programmer has made a few more changes to the site...the product pages in some cases still seem slow though?

 

http://www.sandalstore.co.uk/index.phpVisit My Website

 

What do you reckon it could be now??

 

no, these are not sql queries/timings, this is the total count of page hits by visitors.
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...