On 13 Nov 2003, at 13:45, Oliver Zeigermann wrote:
Stefano Mazzocchi wrote:TODOmy tests show that JDBCStore passes/fails the same tests of the other stores... so it seems in pretty good shape. What was its problem?
- many oddities including permissions occasionally mixed up (still in spite of ACE fix)
- confusion about branches and versions
- Some sort of "deadlocks" occur on delete and insert when having an isolation level higher than read committed. These can hardly be "real" deadlocks as I only have one thread running :( Any hints?
- tests need to be run
Hmmm. Have you tried the concurrent tests?
no, only single connection ones.
Also, it really should not fail in any of the ordinary test... I have the file store to fail in null lock test only.
I have several warnings and a fail for the lock tests for litmus. I'm looking at the code and well, I must say that lock support is not even close to be compliant as it scans for opaque locks and it's not able to do proper handling of the If: header.
I will report this in anothe email.
- ports to other major databases. I can do Oracle, but will need help with othersisn't plain SQL enough for what we need?
At least the DB schema needs to be adapted. We also need a common subset of SQL supported by all the major databases. This has to be determined practically, I guess. Additionally, there *always* is the difference in blob handling between Oracle and the rest of the world.
I see. My personal suggestion would be: get it working solid on MySQL and Postgres and patches will flow in for those who need it for other servers. Code is useless without people maintaining it.... so it's better if we keep the lazyness and wait until somebody that cares shows up.
To my complete DISMAY performance measurements showed no significant difference to the "untuned" version. *Sigh*bummer... maybe the database schema needs a redesign?
The schema looks good to me, but I will start a new thread discussing it.
Ok
how do you run those performance tests?
As I said, just puttting, reading, and finally deleting a large directory tree. Have a look at the quoted parted of the message you replied to.
Do you have any test corpus or do this by hand? I still have to get the test corpus contained in slide working.
But you are right, I only tested this with MS SQLServer with MS JDBC driver. So, I have to do proper tests later.
Hopefully you'll get commit access soon so that we can synch on what you're doing.
sorry for the ton of questions, but I'm trying to get up to speed so that I can help more effectively.
Thanks for all those questions :)
You are very welcome!
-- Stefano.
smime.p7s
Description: S/MIME cryptographic signature
