On Sun, Jan 4, 2009 at 2:45 PM, Geir Magnusson Jr. <[email protected]> wrote: > > How many inserts a second can you do on your machine?
This the command I'm using to insert into the db: ab -c 10 -n 1000 -p emptypost -T 'application/json' http://127.0.0.1:5984/test_suite_db where emptypost is a file that contains '{}' On my white Mac Book (OS 10.5.6, erl version 5.6.3) I'm getting roughly 160 inserts per second. The full ab output is pasted below. I'm inserting into a very small database (started nearly empty). I'd be interested to see the results of inserting into a multi-GB database. Also, maybe my Erlang is old enough not to be effected by the fsync thing. Server Software: CouchDB/0.9.0a731141-incubating Server Hostname: 127.0.0.1 Server Port: 5984 Document Path: /test_suite_db Document Length: 70 bytes Concurrency Level: 10 Time taken for tests: 6.342 seconds Complete requests: 1000 Failed requests: 267 (Connect: 0, Receive: 0, Length: 267, Exceptions: 0) Write errors: 0 Total transferred: 281695 bytes Total POSTed: 150000 HTML transferred: 69695 bytes Requests per second: 157.69 [#/sec] (mean) Time per request: 63.416 [ms] (mean) Time per request: 6.342 [ms] (mean, across all concurrent requests) Transfer rate: 43.38 [Kbytes/sec] received 23.10 kb/s sent 66.48 kb/s total Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.4 0 4 Processing: 39 63 6.3 62 102 Waiting: 39 62 6.1 61 102 Total: 39 63 6.3 62 102 Percentage of the requests served within a certain time (ms) 50% 62 66% 64 75% 65 80% 67 90% 70 95% 75 98% 82 99% 86 100% 102 (longest request) -- Chris Anderson http://jchris.mfdz.com
