Re: Databases for a Concurrent World

2010-07-11 Thread Marko Kocić
I'm not sure how relevant the benchmark is, since all it tests in throughput of database insert operations. The combination of insert, update, delete and selects with more even distribution of operations will be much more helpful, but much harder to test. > If the whole premise of the blog post tu

Re: Databases for a Concurrent World

2010-07-11 Thread Heinz N. Gies
On Jul 10, 2010, at 4:10 , David Nolen wrote: > Some benchmarks thoughts on various databases + aleph. > > http://dosync.posterous.com/22516635 > > Cheers, > David Out of curiosity, mind to give it a try with stupiddb? I am very interested how much the saving of stuff from memory makes things

Re: Databases for a Concurrent World

2010-07-10 Thread Adrian Cuthbertson
> To test with pooled DB connections I thought I'd mention Apache Commons > dbcp. Its a generic connection pool library that could be used for any jdbc > connection. There's also the lighter-weight MiniCollectionPoolManager. See http://www.source-code.biz/snippets/java/8.htm -Regards, Adrian. --

Re: Databases for a Concurrent World

2010-07-10 Thread Miki
Hello David, > http://dosync.posterous.com/22516635 I'm interested to see what will be CouchDB numbers when there are indexes on the data. In my experience, this is a speed killer. All the best, -- Miki -- You received this message because you are subscribed to the Google Groups "Clojure" group

Re: Databases for a Concurrent World

2010-07-10 Thread Allen Johnson
Here are my examples for mysql and postgres using commons-dbcp. They are exactly the same except for the connection info. Might want to play around with the initial,min,max size properties. [MySQL] http://gist.github.com/470901 [PostgreSQL] http://gist.github.com/470904 Just download and include

Re: Databases for a Concurrent World

2010-07-10 Thread Allen Johnson
To test with pooled DB connections I thought I'd mention Apache Commons dbcp. Its a generic connection pool library that could be used for any jdbc connection. I'd post a example clojure usage but I'm afk atm. The lib's BasicDataSource is probably all you'd need. Depends on Commons pool. Just pla

Re: Databases for a Concurrent World

2010-07-10 Thread Toni Batchelli
I think what you're doing is great. I understand you're using ab for these tests, right? What are the actual settings that you are using? Also, I'd like to mention that what these tests are showing is the behavior of the server under constant load (constant frequency in the arrival times of the re

Re: Databases for a Concurrent World

2010-07-10 Thread David Nolen
On Fri, Jul 9, 2010 at 11:08 PM, tbatchelli wrote: > Hi David, > > Out of curiosity, how are these tests connecting to the database, > especially in the cases of MongoDB and CouchDB? In the case of CouchDB > you're clearly using HTTP in a way that it creates one connection per > request, I believ

Re: Databases for a Concurrent World

2010-07-09 Thread tbatchelli
Hi David, Out of curiosity, how are these tests connecting to the database, especially in the cases of MongoDB and CouchDB? In the case of CouchDB you're clearly using HTTP in a way that it creates one connection per request, I believe. In the case of MongoDB, the driver provides a connection pool

Databases for a Concurrent World

2010-07-09 Thread David Nolen
Some benchmarks thoughts on various databases + aleph. http://dosync.posterous.com/22516635 Cheers, David -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members