[opencms-dev] CmsCollector performance

[marcio.camurati]

Shi Yusen,

The velocity is really very nice !

Can you give more informations about this project, do you use only simple
collectors like allInFolderDateReleasedDesc or allInSubTreeDateReleasedDesc
for get this information at the OpenCMS resources?

You said at the end for don't worry about the sql problem, this problem
really exit if we use the OpenCMS at CORE it´s really necessary any
modification about sql operation to resolve the performance problem that
Martin post to us ?

Best regards,
Marcio Camurati


Shi Yusen wrote:
> 
> 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
> 
> 
> _______________________________________________
> 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-tp14931100p15850039.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.