Skip to content. | Skip to navigation

Sections
Personal tools
You are here: Home → News & views → Content editing and creation in Plone is faster with archetypes.schematuning

Posted Aug 28, 2009

Content editing and creation in Plone is faster with archetypes.schematuning

by Kevin J. Kalupson
— filed under:

Some bench marks of content editing and creation in Plone with and without archetypes.schematuning installed.

Background

For about the past week I have been working on batch creation of Faculty Staff Directory people for a Plone site that WebLion will soon be hosting.  The site is currently Plone 2.1 and the Faculty Staff Directory is a MS-SQL db with PHPParser making the queries.  These tables have been dumped to csv files, massaged slightly and then processed and combined with python to extract the data and create objects which are sent via xml-rpc to a Plone site for creation or update.  Things had been running 'fast enough' but did start to slow down yesterday when I started to update the Person objects with relationships to the person's specialty.  Erik Rose had mentioned archetypes.schematuning yesterday and the speed up he had seen in another site, so I thought I would give it a try.

Test Environment

 

Here is an overview of the system I am working on and some numbers that I observed.

The records were updated in one request to the wsapi4plone.core XML-RPC webservice using wsapi4plone.client and wsapi4plone.webslinger to pre-process the data before sending any requests.

Environment in which these benchmarks were made:

  • RHEL 5.3 32-bit running in VMWare Fusion.  1 virtual CPU, 1GB RAM.
  • Python 2.4.3
  • Plone 3.2 from Buildout

 

Packages Installed for Plone

Package Version URL
wsapi4plone.core 0.1a3 http://pypi.python.org/pypi/wsapi4plone.core
Products.FacultyStaffDirectory 2.1.1.2 http://pypi.python.org/pypi/Products.FacultyStaffDirectory/2.1.1.2
BioPersonExtender 1.1d1 https://weblion.psu.edu/svn/weblion/biologyDepartment/BioPersonExtender/trunk/
archetypes.schematuning 1.1 http://pypi.python.org/pypi/archetypes.schematuning/1.1
     

 Benchmark Times for the Creation or Update of 244 FSDPerson Records
schematuning installed Create/Update TIME(HH:MM:SS) Records per Second Seconds per Records
FALSE Create 00:22:24 0.18 5.51
FALSE Update 00:04:26 1.09 0.92
TRUE Create 00:04:29 0.91 1.10
TRUE Update 00:01:03 2.87 0.25

 

 

Document Actions

With schemaextender?

Posted by Anonymous User at Aug 31, 2009 01:35 PM

I'm curious to know if these benchmarks were performed with schemaextender available in the instance. Looking at the code it seems strange that the patches would offer much performance improvement to stock Archetypes schema lookup.

Alec Mitchell

Some other products to try

Posted by Anonymous User at Sep 02, 2009 11:20 AM

Hi, As it is a fairly old version of Plone, any chance you could try re-running your benchmarks with experimental.contentcreation, experimental.daterangeindexoptimisations, and experimental.opaquespeedup installed as well and see how the numbers come out? They can all just be installed via buildout putting them in the eggs/zcml lines. The daterangeindex one might not make that much difference in this situation, but would be interesting to see. You need to rebuild the effectiveRange index after installing it.

-Matt
Need help now?

Immediate assistance is available during university work hours:

News & views…
Posted Oct 13, 2009 Portlets gone wild with ContentWellPortlets 2.0.1 This new release adds the ability to add portlets to the footer area. It also has 6 portlet managers per area. This means 20 total portlet managers including the 2 on the sides that ship with plone.
Posted Sep 17, 2009 Plone 4 – An interview with Zope News Jan Ulrich Hasecke interviews me for Zope News.
Posted Aug 31, 2009 Web Services API for Plone Alpha 3 Release Details the release of the wsapi4plone.core package and the plans for future releases. The final report of the AtomPub for Plone Google Summer of Code project.
Posted Aug 28, 2009 Content editing and creation in Plone is faster with archetypes.schematuning Some bench marks of content editing and creation in Plone with and without archetypes.schematuning installed.
More news & views…