couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Anderson" <jch...@gmail.com>
Subject Re: document insert rate
Date Sun, 04 Jan 2009 23:14:12 GMT
On Sun, Jan 4, 2009 at 2:45 PM, Geir Magnusson Jr. <geir@pobox.com> 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

Mime
View raw message