Are there already projects using SimPCoRe?

[Georg Wächter]

Hi all,

i'm wondering whether anybody uses this repository implementation in a
real world project. The mysql implementation looks very simple and
therefore i don't know how this performs in a web application with
thousands of nodes when most of the content is stored in a single
table.

Additionally i'm interested in details of the database implementation.
I'have looked only a few minutes into the code and wonder whether the
project is also good for applications that write as much to the
repository as they read. I think the normal case would be to have much
more reads than writes ...

All the best

Georg Wächter

[Sammy]

I have some benchmarking results that can help show the performance of
the PCR.

First I added 5,000 nodes and set 7 properties to each node (35,000
total properties). This took 110.87994909286 seconds. The SQL export
for the table was 5mb in size and had 45,000 rows (total characters in
the 7 properties combined was around 3500 characters).

Then on the root node i called getNodes to retrieve all 5,000 nodes.
This took 0.56678485870361 seconds.

My favorite is that I could retrieve all 5,000 nodes and get all
properties for each node in 13.906414031982 seconds.

Also if you are not happy with the MySQL implementation, you can set
up a more elaborate DB model if you want. This is the beauty of the
PCR - the persistence manager.

-Sam

On Oct 11, 7:00 pm, Georg Wächter <georgwaech...@googlemail.com>
wrote:

[Georg Wächter]

Thanks for sharing the benchmarks. Can you give us a more details
abouth the platform used for testing? Was is a normal desktop
application or a high end server machine? :-)

In the next weeks i'll start a small example project using SimPCoRe
and Zend Framework. Additionally i'll eventually implement a new
PersistenceManager that persists everything in memory and is thus
perfect for unit testing. At the moment i don't have a concrete idea
for the example project, but i think a good idea is to built a Sling
like framework. I'll see whether i can extend the zend disptacher
infrastructure to support this concept. The next thing would be to
develop such a great thing like the sling post servlet.

Has anybody started similar things or is willing to help?

All the best

Georg

[Sammy]

"Was is a normal desktop application or a high end server machine?"

-- normal desktop

"In the next weeks i'll start a small example project using SimPCoRe
and Zend Framework. Additionally i'll eventually implement a new
PersistenceManager that persists everything in memory"

-- we already have one in the works using memcached+; the problem is,
as you may have already guessed - querying. Lucean would be great,
but we are still having internal struggles as to whether or not to
implement such a "heavy" framework ... anyway - good luck !!!

"At the moment i don't have a concrete idea
for the example project, but i think a good idea is to built a Sling
like framework."

-- that's our problem ... we are like kids in a candy store -
implement versioning, or write a PHP sling equivalent

"The next thing would be to develop such a great thing like the sling
post servlet."

-- not that hard actually, just by going off of lars' cheat sheet,
we're half way there; it is the FULL javascript side that is the
difficult part.

-Sam