Hi everyone,
I am using Slide2.1 (binary version) and Tomcat 5.0.28 in production. Slide is
configured with
org.apache.slide.store.impl.rdbms.JDBCStore nodestore (mySql 4.1) and with
org.apache.slide.store.txfile.TxFileContentStore as contenstore.
Production server has about than 40Gb data with more than 10000 files.
Performance is acceptable for all operation except versionControlMethod. This
operation always takes more than 12 sec.
I captured SQL strings generated for this operation, and I found so much SQL
commands.
For example, operation such as
2 Query delete c from BINDING c, URI u where c.URI_ID = u.URI_ID
and u.URI_STRING = '/history'
2 Query delete c from PARENT_BINDING c, URI u where c.URI_ID =
u.URI_ID and u.URI_STRING = '/history'
2 Query insert into BINDING (URI_ID, NAME, CHILD_UURI_ID) select
34, '1', URI_ID from URI where URI_STRING = '/history/1'
.........
every time delete all records which represent versions and insert it
again....etc. For more than 10000 files (all are under version control),
it must to take lot of time.
Is anyone have the same problem ?
Thanks for reading and you help
Vladan
