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.
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.
This is an excellent... ???
There is a problem with the cache?
[attachment cleanup by admin]
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
someone have a solution?
Quote from: ereallstaff on July 04, 2013, 09:24:09 AM
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.
my site: autobofi.sk
site is unlock, but... death :(
Quote from: caesarsk on July 04, 2013, 08:52:55 AM
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.
Quote from: caesarsk on July 03, 2013, 19:54:44 PM
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.
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??
Quote from: caesarsk on July 04, 2013, 22:10:15 PM
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.
Quote
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)
You need in your mysql config
#virtuemart needs at least 95, single language
table_cache = 128M
For every language add 25 MB.
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.
ok, I got it
//edit
report from firebug net panel
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]
Quote from: caesarsk on July 05, 2013, 12:30:43 PM
ok, I got it
//edit
report from firebug net panel
...
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.
Maxim, I fully agree. If it is a vhost, maybe with a weak cpu and at least just 1 or 2 GB of memory with 28 domains, the server provider must be a little bit sick in brain.
Of course. You can easily use a small shop, that means 100 products with 3 images, and normal amount of modules can be handled on a 5 euro per months server. For example here http://lichtsteinewelt.de/ . Just a small shop, no problem.
Of course if you have 14k categories, it is not a small shop anylonger.
Hmmm key_buffer_size 8589934592, does it mean 1024MB?, which would be correct.
read_buffer_size 2097152 seems to be 256 K, that is okey. it must not be more, it is session based
max_heap_table_size 67108864 Should be not more than 25 MB looks like you have 78MB??
Hmm and table_cache is not set?
I think I found two problems
max_tmp_tables 32 Maybe you should increase this to 64 tables or so.
Next problem are this variables
table_definition_cache 16384
table_open_cache 128
thread_cache_size 256
If there is no unit set (KB, M or so), then it is in Bit ( 8589934592b=>1024MB). table_open_cache should be at least 96 MB. I think it is meant 128 MB, but maybe it is using bit and so the server is all the time caching on the harddisk.
ok, thx for help. this hosting is weak, hopefully it will solve dedicated server. thx for help
I hope you are using testing period for this web hosting plan.
With such amount of categories, your project couldn't feel ok in SEO without web site map.
Check, quite informative posts about this issue from Franzpeter ;) in this thread
https://forum.virtuemart.net/index.php?topic=114884.0
So you last resort could be only this sticked thread https://forum.virtuemart.net/index.php?topic=104612.0
Let see is your dedicated hosting is able to create web site map with CSVI help.
hi all,
we finally found the problem (thanks to ISP technical support). very sorry, but this module (http://extensions.joomla.org/extensions/extension-specific/virtuemart-extensions/virtuemart-categories/19955) is causing the problem. I completely forget about it and I apologize to all contributors for my inattention.
I need to solve another problem. so I'm not creating a lot of categories, I need to do some modifications.
description of the situation (categories):
standard solution (category tree)
- Car brand (audi, bmw, VW, ford...) - level 1
-- model car (A1, A2, A3, A4, A5, A6, A7, A8, TT, Q5, Q7...) - level 2
--- car engine type (1,9 TDi, 1,9 TDi quattro, 1,8, 4,2, 3,7) - level 3
---- breaks - level 4
----- front - level 5
----- rear - level 5
---- engine parts - level 4
----- bla bla 1 - level 5
----- bla bla 2 - level 5
----- bla bla 3 - level 5
and others 72 subcategories
I did not have to create XY thousands of categories (rough calculation is 2,5M categories :-\), I want to edit something like this
my solution:
- Car brand - level 1
-- model car - level 2
--- car engine type - level 3
(and now)
- breaks - level 1
-- front - level 2
-- rear - level 2
- engine parts - level 1
-- bla bla 1 - level 2
-- bla bla 2 - level 2
-- bla bla 3 - level 2
and others 72 subcategories
now I have to edit tmpl file to be me after filtered out specific motorization (brand -> model -> engine type) dont show product, but another subcategories tree (break part, engine part, body etc.) and then show specific products.
any suggestions how do I achieve this?
Quote from: caesarsk on July 10, 2013, 21:19:54 PM
any suggestions how do I achieve this?
The next time I'll see the guy who have thousands or millions categories immediately will show me that poor try to work without custom fields and without manufactures.
MY suggestion for you - study Virtuemart system a bit deeply next time.
thx for your reply, even if it is very creative, its information value is equal to zero. if you have a solution, I say thank you.
i need use categories, custom fields for me is not the solution.
solution is probably update this code in the file components/com_virtuemart/views/categories/view.html.php
$category->children = $cache->call( array( 'VirtueMartModelCategory', 'getChildCategoryList' ),$vendorId, $categoryId );
Whereas the need to preserve the original function of this code must be used IF.
It will look like this:
i create category tree:
- car parts
-- car brand
--- car model
---- car engine type
- subcategories
-- breaks
--- front
--- rear
-- engine
--- bla bla 1
--- bla bla 2
--- bla bla 3
(and other subcategories)
- tires
- fluids and oils
if (in SQL table prefix_virtuemart_categories field category_name == "car parts") {
if (last category in "car parts - car engine type") {
trace to category "subcategories" while maintaining the filter car parts -> brand -> model-> engine type, and then show filtered products;
}
} else {
$category->children = $cache->call( array( 'VirtueMartModelCategory', 'getChildCategoryList' ),$vendorId, $categoryId );
}
can someone help me with a specific code?
thx
Quote from: caesarsk on July 11, 2013, 02:13:17 AM
thx for your reply, even if it is very creative, its information value is equal to zero. if you have a solution, I say thank you.
i need use categories, custom fields for me is not the solution.
Ofc value of my reply is equal to zero for guy who don't motivated to get back to planning stage in the process of creating his shop.
You not accidentally had problem with BOH module.
Something goes really really wrong with your project and this was just first signal.
As I wrote you could have problems in future with indexing your shop by google and with creating web site map. Thus problems in SEO.
You not using categories, you OVER use them.
Instead of hundreds categories, you're trying to use thousands and millions of them.
Try to tell here your very important reasons why you "need use categories" and "custom fields for me is not the solution".
I can't see why you keep this in secret.
so again, if you have a better solution (specific please), I'll be very happy to learn.
// edit
well, I'm probably an idiot, and my solution is wrong. Here is a link (http://www.autokelly.sk/#PATH=3345620|CT=16|SD=1) to what I want to achieve. if anyone has a solution that is better, very much please the lesson.
Quote from: caesarsk on July 11, 2013, 09:58:47 AM
so again, if you have a better solution (specific please), I'll be very happy to learn.
if anyone has a solution that is better, very much please the lesson.
Guys, keep in mind mentioned solution could help to test Virtuemart under pressure of couple millions of categories. Hah!
Quote from: caesarsk on July 11, 2013, 09:58:47 AM
so again, if you have a better solution (specific please), I'll be very happy to learn.
Maybe this VM2 shop might serve as a working example for you: http://www.westmidlandsvwparts.co.uk/
thx jjk for example, but this shop is small for me. I imported to the shop all categories (14056) and VM running fast. at this point I dont see the problem. I have a problem to write code to work approximately the conditions under which I wrote above. I'm working on it.