Forums / Install & configuration / ezcontentclass.version = '0'
Gernot Rief
Sunday 25 April 2004 9:32:51 am
hi! we're running into a BIG performace problems using ezp 3.3. (starting conditions: ~300000 objects, ~4500000 attributes, 2x xeon 2G, 2G RAM, hw raid, etc.) so what we're trying to do is to reduce joins whereever we can. question: ezcontentclass.id = ezcontentobject.contentclass_id is this join really necessary.it seems that ezcontentclass.version = '0' is hardcoded into the scripts and never changes?
lg,gernot
Jan Borsodi
Monday 26 April 2004 12:59:04 am
Could you please state where (the file) you found the SQL query?Makes it easier to say if it is needed or not.
-- Amos Documentation: http://ez.no/ez_publish/documentation FAQ: http://ez.no/ez_publish/documentation/faq
Monday 26 April 2004 1:07:58 am
hi!
there they are (sorry, no line-numbers):
classes/ezcontentobject.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0 content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0 content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0 content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0 search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' andsearch/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
Tuesday 27 April 2004 4:51:18 am
It is required since there are fields fetched from the ezcontentclass tables, e.g the name is fetched several places. If you know of places where it is no longer needed you can create a bug report for it.
The reason for the ezcontentclass.version = '0' is to only join with classes that are stored, not the temporary ones.