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