3 ms·
Wait, is this supposed to be good performance? This is terrible performance. Those query times are just awful, unless it's a completely cold index. I've seen
by justin_vanw 15y ago
Wait, is this supposed to be good performance? This is terrible performance. Those query times are just awful, unless it's a completely cold index.
I've seen a variety of tools (mysql, postgresql, solr, sqlite) load data and query data far far faster than this, on my laptop even. 100x faster than this on harder data sets for the query time, using basically out of the box solr or postgresql full text search. The load times are also not really impressive at all. (I just searched for "nintendo wii" sans quotes on my development solr instance, 35GB index, I didn't prime this query, 44ms. Follow that up for a query for nintendo: 1ms, nintendo wii: 1ms. On a laptop.).
- jondot 15y agoRelevant for your comment as well as others, RavenDB uses Esent as backend: https://github.com/ravendb/ravendb/tree/master/Raven.Storage.Esent https://github.com/ravendb/ravendb/tree/master/Raven.Storage... http://en.wikipedia.org/wiki/Extensible_Storage_Engine http://en.wikipedia.org/wiki/Extensible_Storage_Engine http://trycatchfail.com/blog/post/Alternatives-to-Relational-DBs-ESENT.aspx http://trycatchfail.com/blog/post/Alternatives-to-Relational... Notice "DivanDB" in the blogpost :). so, there it is.
- jbigelow76 15y agoSweet baby Jesus, RavenDB is Microsoft Access with JSON on top! I'm all kinds of conflicted now :)
- jeffesp 15y agoThere are two MS "JET" database implementations. One that runs access, and then this one. I think this one is commonly referred to as JET blue. The Access one is called JET Red. This is outlined in the wikipedia article linked in the parent.