Forums / Install & configuration / ezcontentclass.version = '0'

ezcontentclass.version = '0'

Author Message

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

Gernot Rief

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' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and

lg,
gernot

Jan Borsodi

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.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq