Lot of product = EXTREMELY slow...

[Khaostar]

Hi everyone,

I just need a little advice. I'm building a site with virtuemart. The shop has over 600 000 products. Everything works fine, but this is extremely slow since I have imported the products. I know that 600 000 is enormous, but do you have any advice to make the site faster?

The site is on a dedicated server.
VM 2.0.20b
Joomla 2.5.14
PHP 5.3.3

Thanks!

[Khaostar]

Bump! Anyone?

[AH]

the new vm 2,1 (or whatever will run on joomla 3) is supposedly much faster. But still in testing

[jjk]

The site is on a dedicated server.
VM 2.0.20b
Joomla 2.5.14
PHP 5.3.3

Are you still using those old versions on your server? Also, just saying it's slow with 600000 products is not a lot of information about your shop configuration. If you can supply more details and/or a link to the shop, you might receive some suggestions.

[Khaostar]

Hi!

Thanks for the replies. Yes i'm still using the version in the original post.
Here is the link to the site : http://joomla.genicolor.com . It talks by it self

[jenkinhill]

You really should update your Joomla & VM versions as both have known critical security issues. http://forum.virtuemart.net/index.php?topic=118683.0   (but obviously test on a backup of the site first). With the latest VM versions as well as better optimised code, you can now use Joomla's cache to speed things up.

In addition there are speed advantages to be gained using PHP5.4 rather than 5.3 (and 5.4 is now recommended for Joomla 2.5)

There are other things that can be done to speed things up, but better to start with the basics.

[Khaostar]

hi jenkinhill,

Thanks for your answer. The problem is that the Template I have bought (from Template Monster) is not compatible with newer version of virtuemart. I asked them to fix the bugs but they don't want to do anything. Also, I have no doubt that this could help, but actually the side is vrey very slow... I'm not sure that upgrading will help that much.

Anyway, I'll try to update virtuemart and fix the bugs by myself in the template. I'll ask for a PHP upgrade too.

Thanks!

[Khaostar]

Here is a little update :

I just fixed the bugs in the template and updated Joomla and virtuemart. It was only some javascript conflict that was causing the bugs with the template.

So, I have moved everything to http://joomladev.genicolor.com for the moment. This site is actually running Joomla 2.5.18 and Virtuemart 2.0.26d. I'm actually talking to the hoster to update to PHP 5.4, but so far I don't see any improvment in performance. Still very very slow.

[jjk]

On your homepage the slowest part is your slideshow. Takes approximately 4 seconds to load.
Currently you also have a 404 not found error for ...joomladev.genicolor.com/modules/mod_virtuemart_cart_tm/assets/vmprices2.js
Also I think your template in general is pretty slow, because it loads a lot of extra javascript and css compared to a lightweight template.

Just curious - where did you place your product images? Is it something like 1 million jpg files all in the VM default image folder?

[Khaostar]

Hi,

Thanks again for your support.

I have tested the site with only 50 000 products instead of 600 000 and it works like a charm. So I don't think that the template or the slider is a part of the problem.
the 404 error is "normal". I have desactivated this file because it was causing javascript conflict on the site and some features was not working. I bought the template on Template Monster and yes, it has alot of extra files. I'll have to do a little clean up eventually, but I don't think that this is causing any problem related with the slow queries.

For the images, I only have two. One for the touch up pen and one for the spray can. The background colors are generated with the RGB code from custom fields. So I don't have 600 000 images on the server. Don't worry!