search

ropensci / nodbi

Document DBI connector for R
https://docs.ropensci.org/nodbi
Other
76 stars 6 forks source link

Benchmarking #8

Closed richfitz closed 2 years ago

richfitz commented 9 years ago

@sckott has run some benchmarks for different key/value stores: it'd be good to revive these and run them for the low-level things that we're trying: cost of serialising a dataframe by row to different backends, etc. That'd help us work out which database is going to be most useful and for users and developers to work out what database would best suit their application.

jeroen commented 9 years ago

That sounds a bit premature though; speed of an early implementation might not be representative for the database. For example I implemented a 10x speedup today.

richfitz commented 9 years ago

Sweet. However, I think that getting some measure of "par" up early would be nice and help motivate other 10x speedups. But it can also wait, too.

jeroen commented 9 years ago

I think it's more important to make things work on all platforms and come up with a nice interface before worrying about performance. There is all kind of crazy stuff that you can do to optimize, but remember: premature optimization is the root of all evil :)

sckott commented 9 years ago

Definitely interested in benchmarks, but does make sense to focus on the user interface first

rfhb commented 2 years ago

@richfitz @sckott @jeroen nodbibenchmark added to README, using local CouchDB, Elasticsearch, MongoDB, SQLite and PostgreSQL; please see https://github.com/ropensci/nodbi#benchmark.