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