Hey guys and gals.
First I just wanted to share my experience with Slide for the last week.
One of our apps started to hang on every PUT into the Slide
repository that is running a custom JDBC store on top of Oracle.
I really though the problem was the sequential mode and the isolation
level in the database but then I discovered that the PROPERTIES table
for Slide in the Oracle DB
suddenly had 850000 records in it which seems like ALOT considering
the repository only contains about 200 files at most (but a lot of
user folders though).
The effect of so many records was that the upload (OR rather the
preparation for the upload) that Slide does (selecting data etc.)
would take forever!
And effectively locked some tables while it was at it. So I tried to
figure out some indexes to speed things up and these seem to work
very well and seem to be necessary actually!
Has someone else figured out some tuning for a database driven Slide
store? Anything would help!
CREATE INDEX properties_idx1 ON properties(version_id,property_name);
CREATE INDEX binding_idx1 ON binding(name);
CREATE INDEX binding_idx2 ON binding(uri_id,child_uuri_id);
CREATE INDEX locks_idx1 ON locks(object_id,lock_id,subject_id,type_id);
CREATE INDEX object_idx1 ON object(class_name,uri_id);
CREATE INDEX parent_bind_idx1 ON parent_binding(name);
CREATE INDEX parent_bind_idx2 ON parent_binding(uri_id,parent_uuri_id);
CREATE INDEX permissions_idx1 ON permissions
(object_id,subject_id,action_id);
CREATE INDEX permissions_idx2 ON permissions(succession);
CREATE INDEX permissions_idx3 ON permissions(object_id);
CREATE INDEX uri_idx1 ON uri(uri_string);
CREATE INDEX uri_idx2 ON uri(uri_id,uri_string);
Secondly I have a problem with the RE-indexing of a Slide store. I
deleted the index and restarted tomcat and the RE-indexing starts.
Then the memory usage skyrockets, not by some tens of megabytes but
by hundreds of precious MB's at once and then gives me a OUT OF
MEMORY error and a failed transaction when it stops at 1500MB of RAM!
Has anyone had this problem? First of all, why does the Slide-Lucene
index use transactions? Its writing to files in the file system right?
And what's with the memory feast?
Best regards
Eiki
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Eirikur S. Hrafnsson
Chief Software Engineer
[EMAIL PROTECTED]
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Idega hf. ı Engjavegi 6 ı 104 Reykjavík ı Iceland
Tel. +354 554 7557 ı Fax +354 885 7557
http://www.idega.com ı [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
