<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I have problems with very poor performance of Collectors, specialy with
allInFolderDateReleasedDesc and allInSubTreeDateReleasedDesc. I have
site with about >10000 articles categorized in folders, so i have
this structure
<br>
<br>
/Categories
<br>
/Categories/Cat1
<br>
/Categories/Cat2
<br>
/Categories/CatX
<br>
...
<br>
<br>
in Cat1, CatX i have page which shows articles in whole category (with
paging by 20 articles)
<br>
on homepage i have 20 newest articles from all categories
<br>
I use something like:
<br>
<cms:contentload
<br>
collector="allInSubTreeDateReleasedDesc" param="<i
class="moz-txt-slash"><span class="moz-txt-tag">/</span>Categories<span
class="moz-txt-tag">/</span></i>|magArticle|20"
<br>
editable="true">
<br>
<br>
respectively in cat1
<br>
<cms:contentload
<br>
collector="allInSubTreeDateReleasedDesc"
param="/Categories/Cat1/|magArticle"
<br>
pageSize="20" pageIndex="1" editable="true">
<br>
<br>
Performance is very poor, I looked to source code and see that CMS
works (for my HP for exmaple) in this way:
<br>
Load /Categories resource from DB, Create CmsResource
<br>
Load all 10000 under /Categories resources from DB and Create
CmsResource objects for it
<br>
Sort all 10000 CmsResources by ReleaseDate
<br>
throw 9980 unneeded objects !!!
<br>
return 20 CmsResources
<br>
<br>
It's really crazy.
<br>
<br>
Is there a way how to optimize it ?
<br>
<br>
Why data is not sorted on SQL server and returned only 20 items in
recordset ?
<br>
<br>
I thing that it's really performance problem, waste of CPU and memory.
<br>
<br>
This operation takes about 2,3min on my server (CPU 2xQuadCore 2,4GHz,
4GB RAM, 8xHDD on 3WareCard in RAID6) on my old server with AMD64
Opteron and 4HDD in SW RAID it takes about 14minutes !
<br>
<br>
Martin
<br>
</body>
</html>