Author Topic: Virtuemart really slow!  (Read 7247 times)

xnoybis

  • Beginner
  • *
  • Posts: 4
Virtuemart really slow!
« on: September 14, 2010, 11:01:18 am »
Hi all:

I'm new to this forum, and also very new to virtuemart, so I hope I don't appear too ignorant.

A few days ago, the site I designed/am maintaining: http://www.gohd.com.sg kept giving me: fatal error: maximum execution time of 30 seconds exceeded on [some line from some virtuemart file, always different for each error]

I have no idea why it said that, so I changed the php.ini file to make the maximum execution time 90 seconds. This has stopped giving me the error, but the site is really really really slow. Take a look.

In addition, when I have debug on, I get 700+ queries logged, and jos_session gives a huge, huge string. In addition, I have an equal number of legacy queries logged, which means there's 1400+ queries logged? I think it may be the categories that are slowing it down, but I've heard that sites with 10,000 products load pretty fast - I have only 1,000 or so products, and there's no reason it should be so slow.

I have installed some hacks before, and there's SEF on. I have also optimised all the databases. Still nothing.

Anyone? Would really appreciate any help. I'm using Joomla 1.5.15 with VM 1.1.4. I have uploaded the debug info in a text file to http://www.gohd.com.sg/vm_queries.txt. The output is for the main page!

Thanks in advance.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 25909
  • Always on vacation
    • Jenkin Hill Internet
Re: Virtuemart really slow!
« Reply #1 on: September 14, 2010, 23:40:30 pm »
Try Virtuemart 1.1.5 which handles queries more efficiently.

SEF will slow a site down (sometimes considerably) so only use that if absolutely necessary..
Kelvyn

Jenkin Hill Internet,
Keswick, Lake District

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.3.9579 on Joomla 3.7.3 PHP 7.0.19

Testing VMVM3.2.3.9587 on J!3.7.3

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3113
  • using Piwik instead of Google Analytics
Re: Virtuemart really slow!
« Reply #2 on: September 15, 2010, 09:23:07 am »
I just had a look at your website. From my location in Germany the website loads with a reasonable speed. Compared with my own VirtueMart website (which is not life yet and sells art prints instead of books) the primary speed problem of your site is probably the result of image resize activity.

On my website I disabled VirtueMart's 'image resize' function. Instead I upload thumbnails and large images which already have the size I want them to display. On my category view the thumbnails (larger than yours) typically load in 32ms. On your website it seems to take somewhere between 1.5s and 5.0s.You can see that if you use the firefox browser and install the 'Firebug' plugin. If you start firebug and select the "Net" button, it will record the loading speeds of your website elements.

However, your Joomla template graphics don't load very quick either. It is also possible that your website is hosted on a slow server or some of your 60+ fellow users on the same server produce heavy loads.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

xnoybis

  • Beginner
  • *
  • Posts: 4
Re: Virtuemart really slow!
« Reply #3 on: September 15, 2010, 12:30:34 pm »
Hi jenkinhill and jjk:

Will upgrade to 1.1.5, thanks. That make take care of some of the useless queries.

However, you correctly identified the problem: SEF plugin. When I disable that, a page that takes 14 seconds to load takes 2 seconds or less (thanks for the firebug tip - that's how I found this out). This is crazy! My client really needs SEF, so I need to find a good SEF plugin for VM. I was using vmSEF, which is good, but far, far too slow. 80-90% slowdown because of SEF is not feasible, but I really need it. Arg.

jjk: I see what you mean about the image resize issues. However, I am ok with a 2-5 second loading time, which is what I get without the SEF. I will have to re-upload thumbnails for 1000 products, which is gonna be too much hassle for a small improvement in performance.

Now to look for a good SEF plugin for VM! Can't seem to find one at all.

Thanks for your help.

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3113
  • using Piwik instead of Google Analytics
Re: Virtuemart really slow!
« Reply #4 on: September 15, 2010, 12:46:24 pm »
Concering vmSEF - Did you read this already?
http://www.tinkeltools.com/sef-links-for-virtuemart-with-vmsef.html
Looks like the new version of vmSEF is quicker, but just became commercial. However, the developer currently doesn't mention a price on his website.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

xnoybis

  • Beginner
  • *
  • Posts: 4
Re: Virtuemart really slow!
« Reply #5 on: September 15, 2010, 17:41:36 pm »
Yes! I'm on it.

The developer told me that they are working on the new release, and he will let me know when it's done.

Fingers crossed and lots of caching until then. I just hope it doesn't affect the online sales all that much! The visitor count has taken a nosedive recently.

hamedhm

  • Beginner
  • *
  • Posts: 3
Re: Virtuemart really slow!
« Reply #6 on: November 04, 2011, 07:28:10 am »
dear experts,
my virtuemart website is too slow to load,sometime it takes 30s to load a page!!!
please as experts help me to solve this problem,the address of EXP page is:
http://irank.ir/index.php?page=shop.product_details&category_id=1&flypage=flypage.tpl&product_id=7057&vmcchk=1&option=com_virtuemart&Itemid=58

username: test
password: test

and another problem is that my webshop is just for registered users! but I set publich in backend, please help me in these 2problems
thanks alot

pacecdn

  • 3rd party VirtueMart Developer
  • Beginner
  • *
  • Posts: 6
  • PaceCDN - Delivering Your Content
    • PaceCDN
Re: Virtuemart really slow!
« Reply #7 on: December 11, 2014, 11:48:26 am »
Try this plugin:
http://codingmall.com/products-mainmenu-8/65-speed-up-virtuemart

I've got great success using this plugin in the past.
Speed up websites with PaceCDN.com