eZKeyword optimization

Author Message

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

Denitsa M.

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

Iguana IT - http://www.iguanait.com

Piotrek Karaś

Sunday 27 September 2009 2:49:27 am

Denitsa M.: Might help to set KeywordNodesCacheClearLimit setting in viewcache.ini, its a 4.1 feature though.

Was that the major ezkeywords performance problem, Andre?

Cheers,
Piotrek

--
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

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.