Slow performance - 180.000 products

[dcsupp]

Hello All,

I have set up this e-shop (it runs on Joomla! 2.5.8 / Virtuemart 2.0.8c), it currently has 110 categories containing 180.000 products, it's a book store website.
http://librarybooks.gr/index.php


Although I have updated Virtuemart to 2.0.16 version (also tried clean installation), the problem remains the same but I had to roll it back to version 2.0.8c due to compatibility issues with the eCommerce software.

The problem is that the site runs far too slow, even the search module is slow !!!

I was looking into this problem but didn't find anything useful ! I even tried JCH_Optimize_2.0.2 / compression / cashing , makes no difference !

Global Configuration
Search Engine Friendly URLs - Off
Use URL rewriting - On
Adds Suffix to URL - Off
Unicode Aliases - On (due to Greek product names)

.htaccess
RewriteEngine on
RewriteCond %{HTTP_HOST} ^libraybooks.gr
RewriteRule (.*) http://www.libraybooks.gr/$1 [R=301,L]

#If available, set the expires to 'far future'
<IfModule mod_expires.c>
   ExpiresActive On
   ExpiresDefault "access plus 1 month"
   ExpiresByType application/pdf "access plus 1 month"
   ExpiresByType application/x-javascript "access plus 1 week"
   ExpiresByType application/x-shockwave-flash "access plus 1 month"
   ExpiresByType image/gif "access plus 1 month"
   ExpiresByType image/ico "access plus 1 month"
   ExpiresByType image/jpeg "access plus 1 month"
   ExpiresByType image/png "access plus 1 month"
   ExpiresByType image/x-icon "access plus 1 month"
   ExpiresByType text/css "access plus 1 week"
   ExpiresByType text/html "access plus 1 day"
   ExpiresByType text/plain "access plus 1 week"
   ExpiresByType video/x-flv "access plus 1 month"
</IfModule>

#Turn off ETags
FileETag none

# DirectoryIndex Protection
Options -Indexes
DirectoryIndex index.html index.php /index.php




Is there a way to make to shop runs faster ? Any suggestions would be appreciated !



Thank you in advance for your time and effort.

[jjk]

I don't see anything which is loading extremely slow. Just a few hints you could think about:

It seems that you are loading two versions of jquery.min.js, which can produce conflicts:
1. ...//librarybooks.gr/plugins/system/modalmessages/assets/js/jquery-1.8.3.min.js
2. ...//ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js
Personally I would disable the one from Google in VM2 configuration, because their service often is pretty slow due to too many simultanious requests (I suppose).

Slide shows often slow down a website quite a bit, too.
I think your accordion menu has a hickup somewhere in: ...//librarybooks.gr/modules/mod_iNowSlider/js/jquery.mobile-1.0rc2.customized.min.js"

Your site (problably your template) seems to load Webfonts from Google (although I don't see a webfont file in the list of loaded files). This often is another time-consuming process.

Maybe there are also a few things you can tweak on your server.