Just a note! My testing of the J2EE store showed a big difference between the JDBC driver vendors! Microsoft was clearly the slowest one of the drivers I did tests on!
One of the better ones was from DataDirect! /Jacob -----Original Message----- From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] Sent: 6. november 2003 16:34 To: Slide Developers Mailing List Subject: Re: [VOTE]: J2EE-Adapter or Not MS SQLServer works now too. Forgot to configure JDBC url with SelectMethod=cursor for multiple statements per connection. Your url might look something like: jdbc:microsoft:sqlserver://moe:1433;DatabaseName=Slide;SelectMethod=cursor SQLServer running on a 700MHz P3, 512 MB RAM PUT ~ 70 - 90 secs (!) PROPFIND ~ 17 secs READ ~ 12 - 20 secs DELETE ~ 35 - 45 secs Oliver Zeigermann wrote: > Got the initial version running now. Had to change minor stuff only. > Have no SQLServer installation so tested it on Sybase as this only meant > very little changes in schema and query. Manual tests look good, need to > run the testsuite and especially the concurrent tests... > > Fixes on ACE still missing... > > First impression on performance as compared to the file store. I tested > a large file tree with a PUT, PROPFIND and READ (after a restart to > clear caches) and DELETE. My machine is a 1.4GHz P4 with 512 MB RAM, DB > machine is a 2x800MHz P3 with 1 GB RAM. > > Results are to be considered very rough and preliminary, but there was > no load on the DB machine and network seemed to be almost clear as well. > > Astonishing results anyway! Why is propfind on the DB (isn't more or > less "SELECT * from props" or so) so slow? Why is delete so slow? > > I think some tunneling of requests directly to stores supporting complex > actions would be a very good idea. Will discuss this in a different > thread later... > > Any other experice? > > ----------------------------------------- > J2EE store, compression ON > > PUT ~ 55 secs > > PROPFIND ~ 30-35 secs > > READ ~ 30 secs > > DELETE ~ 45 secs > > ----------------------------------------- > TX file store > > PUT ~ 45 secs > > PROPFIND ~ 12 secs > > READ ~ 10 secs > > DELETE ~ 35 secs > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > . > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
