hi michael,
we had to optimize a shop system with about 800 cats and 14000 variants.
the default loading of an article page was above 7secs (very fast machine)
So we tried to get information about the blockers:
fist we tracked the timing of the buildTree function in cmp_categories.
Timing was really bad and we dumped the generated object of this
function. The dump was about a 7mb big file, which is tooooo big for a
800cat tree.
whe we disabled the option to load full cattree for search an to hide
hidden cats the generated aray got reduced to 60kb.
The Timing of the buildtree function went down about 98%.
So the solution was du build a cronjob to deactivate empty categories
and leave the options in performance Tab unchecked.
grets,
Reinhard Vogl
Am 01.12.2010 13:46, schrieb M. Bladowski:
hi there and hello,
this my first post here ;) i am currently working with an EE v4.4 and
got extrem performance problems
with a shop, that has more than 10k categories inside. as i already
explained in my blog (http://bit.ly/fk3KoN)
the OXID admin area becomes unuseable with such many categories
inside. the only way to work is to
disable the category-options at the performance settings. at the
frontend - of course - we want to show
the category tree and this is a real problem. working with articles is
not possible if you have so many categories
and sub-categories - because oxid creates the full tree inside to show
it at drop-downs and other places....
from an EE-version i expact more performance than waiting 90seconds
loading an article or the article-list ;-(((
does anybode here has a solution for me, working with good performance
at the admin-area, without
disabling the performance-options for categories ???
i think it´s not a exceptional case having so much categories, so i am
wondering how other big shops
are handling this issue. of course we are working with the SOAP API in
this case, but a manual view
of articles and categories should be possible without waiting minutes
to see something ;)
so thank you for any help/tip/solution!
michael bladowski
--
____________________________________
Reinhard Vogl
Technische Leitung
DeutscheDaten
Portal- und Plattformlösungen GmbH
Gabrielenstraße 9
80636 München
Amtsgericht München: HRB 160521
Telefon: 089 542 742 43
Internet: www.deutschedaten.de
____________________________________
_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
