VirtueMart Category dTree Module - SQL Problem

[spinacz200]

Hello all,

I have very big problem - I'm using VirtueMart Category dTree Module to display my categories from Virtuemart 2.0.6 based online catalogue. I have about 130 categories. I've noticed that this module is qenerating about 1000 MySQL Queries (about 130 in catalogue when disabled and 1100 when enabled).

I have tried to find out a solution of this problem, but I haven't found any.

Is is any way to successfully cache queries for this module or optimise tree building argorithm? Joomla cache decreases amount of queries to 500-600, but it is still too much.

This module is the best for my catalogue and it would be great if it is possible to solve this problem.

Thanks in advance and best regards,
Szymon

[Jan]

Hi, try to customize the code - see the module code on place:

Code: Select all

//$parentCat 	= $cache->call( array( 'VirtueMartModelCategory', 'getParentCategory' ), $c->virtuemart_category_id );
			$parentCat	= $categoryModel->getParentCategory($c->virtuemart_category_id);

Jan

[spinacz200]

Hi,

I have tried to edit PHP code of this module and opimise that, but unfortunately I"m not able to do it on my own. Could I ask you for some quick tip, which could help me here? I have also searched for some easy tutorial about enabling cache system in custom module, but I haven't seen anything useful.

Thank you,
Szymon