On Jan 4, 2009, at 6:14 PM, Chris Anderson wrote:
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 '{}'
Ok, I'll try that. Can you post a document with data though?
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.
I dunno - apparently the F_FILESYNC is a recent thing, and Boy Howdy!
it's slow...
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
