On 13 Nov 2003, at 12:36, Oliver Zeigermann wrote:
Status report of J2EE-Store. Some stuff done, big amount of work left...
what is the difference between a J2EE store and a JDBC store?
DONE (with substantial support of my collegue Daniel Florey)
- ordering of ACEs work now / was harder than I thought :(
- at most one open statement per connection now
- combined time consuming queries into one
- made all statements prepared (also for performance)
- removed "myRevisionDescriptor"-hack
- some cleaning, resulting class is only half the size of original version
cool
TODO
- 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
my tests show that JDBCStore passes/fails the same tests of the other stores... so it seems in pretty good shape. What was its problem?
- ports to other major databases. I can do Oracle, but will need help with others
isn't plain SQL enough for what we need?
To my complete DISMAY performance measurements showed no significant difference to the "untuned" version. *Sigh*
bummer... maybe the database schema needs a redesign?
Because this version is cleaned and at least does *not run slower* and some deadlocking spots have already been removed, I proposed to continue on this track.
Comments?
how do you run those performance tests?
sorry for the ton of questions, but I'm trying to get up to speed so that I can help more effectively.
-- Stefano.
smime.p7s
Description: S/MIME cryptographic signature
