[opencms-dev] CmsCollector performance

[marcio.camurati]

Hi Martin,

I read you post, and see you cenario at our future project that is at the
begin yet, the performance is one of our concern about use the OpenCMS to
manage the content of the site, do you have any good news about your
performance problem ? or it continuos ?

If you can tallk more obut it or about the solution that you do for it.

Best regards,
Marcio Camurati


Martin Bednář wrote:
> 
> 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
> 
> /Categories
> /Categories/Cat1
> /Categories/Cat2
> /Categories/CatX
> ...
> 
> in Cat1, CatX i have  page which shows articles in whole category (with 
> paging  by 20 articles)
> on homepage i have 20 newest articles from all categories
> I use something like:
> <cms:contentload
>    collector="allInSubTreeDateReleasedDesc" 
> param="/Categories/|magArticle|20"
>    editable="true">
> 
> respectively in cat1
> <cms:contentload
>    collector="allInSubTreeDateReleasedDesc" 
> param="/Categories/Cat1/|magArticle"
>    pageSize="20" pageIndex="1" editable="true">
> 
> Performance is very poor, I looked to source code and see that CMS works 
> (for my HP for exmaple) in this way:
> Load /Categories resource from DB, Create CmsResource
> Load all 10000 under /Categories resources from DB and Create 
> CmsResource objects for it
> Sort all 10000 CmsResources by ReleaseDate
> throw 9980 unneeded objects !!!
> return 20 CmsResources
> 
> It's really crazy.
> 
> Is there a way how to optimize it ?
> 
> Why data is not sorted on SQL server and returned only 20 items in 
> recordset ?
> 
> I thing that it's really performance problem, waste of CPU and memory.
> 
> 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 !
> 
> Martin
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 

-- 
View this message in context: http://www.nabble.com/CmsCollector-performance-tp14931100p15848425.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.