Forums / Suggestions / eZKeyword optimization
Piotrek Karaś
Friday 19 December 2008 6:26:26 am
Has anyone tried optimizing the ezkeyword queries (those that are generated while accessing content/keyword/... view)? It get's incredibly slow with only few thousands of relations, it practically eliminates it from any tagging-like use...
SELECT ezkeyword.keyword,ezcontentobject_tree.node_id FROM ezkeyword, ezkeyword_attribute_link,ezcontentobject_tree,ezcontentobject,ezcontentclass, ezcontentobject_attribute a1 WHERE a1.version=ezcontentobject.current_version AND a1.contentobject_id=ezcontentobject.id AND ezkeyword.keyword LIKE 'whatever%' AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 2))
-- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
Denitsa M.
Tuesday 12 May 2009 8:15:49 am
Hi,
anyone optimized the ezkeyword? it brings up index speed problem with sorl indexation for both ezfind and ezfind2 - the index time difference is huge when we have objects with ezkeyword attributes and when we do not have such objects (remove the ezkeyword attributes from the same objects). With ezkeywords server start to swap, mysql gets slow queries log filled up with calls to ezkeyword tables and index time is like up to 5-7 times greater than time when no ezkeyword attributes are used in classes. Also index size for the same objects with and without ezkeywords is enormous. In one case we have XXX BG of index data (with ezkeywords) and in the other case we have like under 100MB.
Iguana IT - http://www.iguanait.com
André R.
Tuesday 12 May 2009 10:11:55 am
Denitsa M.: Might help to set KeywordNodesCacheClearLimit setting in viewcache.ini, its a 4.1 feature though.
http://pubsvn.ez.no/nextgen/stable/4.1/settings/viewcache.ini
eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Tuesday 12 May 2009 11:23:05 pm
Thanks, André,
still at 4.0 here, but I will look into that anyway, it will come the time to use :)
Denitsa
Sunday 27 September 2009 2:49:27 am
Was that the major ezkeywords performance problem, Andre?
Cheers,Piotrek
Marko Žmak
Tuesday 27 October 2009 11:28:46 am
I had the same problem on a site with more than 90.000 objects, most of them (90%) having 4 keywords attributes. To sullution was to switch to ezfind, but than we got another problem, the updatesearchindexsolr.php script takes a lot of time (about 6h) and crashes during indexing. I think it's related to this problem:
http://ez.no/developer/forum/extensions/ez_find/ezfind2_indexing_speed_incredibly_low_er/
-- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth