slow virtuemart - 14000 categories, site death

[caesarsk]

hi all,

i need a little help.

first system info:
site: autobofi.sk (site lock)
joomla 2.5.8
VM 2.0.20a
PHP 5.4.15
memory_limit   128M
output_buffering   4096

I use VM without any "hungry" extensions or modules. i use jotcache, joomla cache enable, products none.
my problem. when i add categories (i have it 14000 - car parts tree), site is very slow. ehm... no slow, site death.
i need a help with this, please. I cant find a solution with my problem.

[Maxim Pishnyak]

Congrats!
You found hosting company that doesn't interested in providing support for websites on shared hosting platform AT ALL.
I used http://2ip.ru/domain-list-by-ip web service and it shows me now that on the same server with your website there're also 28! another websites. Obviously your hosting company just doesn't give your online e-store enough resources. It's time to say them good bye and find another variant.
P.S. Test before buying.

[caesarsk]

This is an excellent... 
There is a problem with the cache?


[attachment cleanup by admin]

[ereallstaff]

Hello I had same problem

Yes virtuemart cache takes a lot of files, and for some strange reasons, it tries to load all files at a glance.

So when the cache is high, the website crashes

I have less products than you, but with progressive cache it crashes also to me.

I had to use normal cache with a little time in order to regenerate every time. This is a real problem

[caesarsk]

someone have a solution?

[Maxim Pishnyak]

Hello I had same problem

I have less products than you, but with progressive cache it crashes also to me.

Pardon me, but VM is just simply wasn't built to use with progressive cache.

AT ALL

Overall your problem is that you didn't post today url to your problematic website.

[caesarsk]

my site: autobofi.sk

site is unlock, but... death

[Maxim Pishnyak]

There is a problem with the cache?

Yes it's problem with the cache.

Problem with the overall speed in general on your hosting.

It's problem with everything on your hosting company.


What IS your problem?

You are not able to find another FAST hosting for your website for the same monthly price?

I KNOW that such not professional hosting company as you have now HAVE a good money on regular basis from webmasters that didn't test own web shops in such resourceless environments.

[jjk]

I use VM without any "hungry" extensions or modules. i use jotcache, joomla cache enable, products none.

Of course we can't see your site when you put it into maintenance mode. However, Joomla cache should be disabled. You certainly don't want to cache the shopping cart (including content and other sensitive data entered into VM forms by your customers). Under no circumstances enable 'Progressive Cache', as this is likely to make your shop unusable. See here for an explanation of 'Joomla cache': http://www.itoctopus.com/why-progressive-caching-in-joomla-should-be-avoided-in-most-cases

Jotcache might work if you manage to configure it correctly (I never used it, so I can't give any tips on how to make it work with VM2).

If you use the Firefox browser, I would recommend to install the Firebug plugin available here: https://getfirebug.com/
The 'Net' tab in Firebug will help you to find elements which are working too slow (often slow websites are caused by slow template features). VM2 itself usually is pretty fast, even with 100000+ products.

A shared server with 28 other domains doesn't mean necessarily that your shop will be slow if the server is managed well (My shop has 74 neighbours on the same server and it is running pretty fast), but it depends on how much server resources your neighbours are consuming.

[caesarsk]

ok. first, thx for reply.
in frontend i dont use any modules or extensions. in backend i used jotcache and other extensions which dont affect frontend.
for designs and configure shop i used firebug with net panel, everything is ok until you load category.
My guess is that the problem is in the database and its settings. table with categories (prefix_virtuemart_categories) have 10,6MB and database statistics report problems with cache, because VM reads / scans the entire table.

edit//
if you have access to the database settings, please, can you write me what values you have ​​to the variables Opened tables or table_open_cache??

[jjk]

My guess is that the problem is in the database and its settings. table with categories (prefix_virtuemart_categories) have 10,6MB

I currently have only 8 categories (in two languages) which consumes only 13kb in the 'prefix_virtuemart_categories' table.

if you have access to the database settings, please, can you write me what values you have ​​to the variables Opened tables or table_open_cache??

On my live website my 'table open cache' uses the default value of '64'.
Open_tables    64
Opened_tables    14356604 (indicates the number of table-opening operations since the server started)

[Milbo]

You need in your mysql config

Code Select Expand


#virtuemart needs at least 95, single language
table_cache = 128M

For every language add 25 MB.

[caesarsk]

database info:
tables 181
rows 59 573
data 17,6MiB
keys 2,2MiB
sum 19,8MiB

MyISAM 
MyISAM storage engine

bulk_insert_buffer_size   65 536 KiB
delay_key_write   ON
Velikost ukazatele na data   6 B
Maximální velikost dočasných souborů pro řazení   1 024 MiB
myisam_mmap_size   18446744073709551615
Automatický režim obnovy   FORCE
Vláken pro opravování   1
Velikost paměti pro řazení   16 384 KiB
myisam_stats_method   nulls_unequal
myisam_use_mmap   OFF
skip_external_locking   ON

sry, I dont know translate this. These settings are all to which I can get. If there is any sql command through which I can pull out all the settings database, please send it to me and I'll find out.

[caesarsk]

ok, I got it

//edit


report from firebug net panel

Code Select Expand


headers tab:

return headers
Connection Keep-Alive
Content-Length 0
Content-Type text/html
Date Fri, 05 Jul 2013 11:25:26 GMT
Keep-Alive timeout=1, max=100
Server Apache/2.2.24 (Unix) mod_fcgid/2.3.7 mod_ssl/2.2.24 OpenSSL/1.0.0-fips
X-Powered-By PHP/5.4.15

request headers
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding gzip, deflate
Accept-Language sk,cs;q=0.8,en-US;q=0.5,en;q=0.3
Connection keep-alive
Cookie aab0e9d00eebd20ba822139822dca8fb=ae24e7a6865cc0da15100b6162125175; jpanesliders_panel-sliders=0; 1e4a319bc7c276f369d95637c056d09b=a32515724c9bcb0cd0caf8d4fb1b290d
DNT 1
Host autobofi.sk
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:22.0) Gecko/20100101 Firefox/22.0 FirePHP/0.7.2
x-insight activate


cache tab:

Data Size 83134
Device disk
Expires Thu Jan 01 1970 01:00:00 GMT+0100 (Central Europe Daylight Time)
Fetch Count 17
Last Fetched Fri Jul 05 2013 13:26:51 GMT+0200 (Central Europe Standard Time)
Last Modified Fri Jul 05 2013 13:28:10 GMT+0200 (Central Europe Standard Time)


[attachment cleanup by admin]

[Maxim Pishnyak]

ok, I got it
//edit
report from firebug net panel

Code Select Expand


...


This wouldn't help you at all. Listing of files that download your web page during own painting could be more interesting.

IF your shared server doesn't respond some unexplainable time while Net tab of Firebug gathers statistic it shows that 28 domains is too much in your case.

I'm not sure at all that Virtuemart out of the box with demo data is able to work on your hosting.