[opencms-dev] CmsCollector performance

[Shi Yusen]

Here is a website we almost completed with more than 50k pages now, and
about 15k-20k more annually. You'll find it's quite fast.
http://www2.scnjw.com/scnjw/index.html

CentOS + Squad + Apache + Tomcat + OpenCms 7.0.3 + Oracle.

Don't worry about OpenCms performance. For the sql problem, you can
write your own performance module to improve the sql operation. It's not
difficult.

Regards,

Shi Yusen/Beijing Langhua Ltd.


在 2008-03-05三的 03:47 -0800，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.
> 
> 
> _______________________________________________
> 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