问题描述
是一个开放源代码的内存数据库,与C ++紧密集成支持类似SQL的查询语言,其中表是类,行是对象)。像大多数IMDB一样,它是为读取访问模式主导的应用程序。针对完全在主存储器(RAM)中读取和写入数据的系统优化算法和数据结构。它应该是非常快,即使与其他内存数据库相比,但我找不到任何基准在线。
FastDB is an open-source, in-memory database that's tightly integrated with C++ (it supports a SQL-like query language where tables are classes and rows are objects). Like most IMDBs, it's meant for applications dominated by read access patterns. The algorithms and data structures are optimized for systems that read and write data entirely in main memory (RAM). It's supposed to be very fast, even compared to other in-memory databases, but I can't find any benchmarks online.
我正在考虑使用FastDB的时间 - 系列数据,在一个项目中,其中1)亚毫秒的随机存取读取延迟,以及2)每秒数百万行的顺序读取吞吐量将是非常好的。
I'm considering using FastDB for time-series data, in a project where 1) sub-millisecond random-access read latencies, and 2) millions of rows per second sequential read throughput would be very good to have.
我找不到很多参考FastDB的第一手经验;有没有人在这里使用它?你可以指向FastDB的任何基准,特别是那些考虑读延迟和吞吐量的基准。
I can't find many references to first-hand experience with FastDB; has anyone here used it? Can you point to any benchmarks of FastDB, especially those that consider read latency and throughput?
推荐答案
Erlang论坛(2009年起):有人(Serge Aleynikov)推荐FastDB用于具有亚毫秒级延迟的交易系统:
A recent post on an Erlang forum (from 2009): http://www.trapexit.org/forum/viewtopic.php?p=49476#49476 has someone (Serge Aleynikov) recommending FastDB for trading systems with sub-millisecond latencies:
看起来人们担心低电平的延迟是非常吓人的;我正在考虑FastDB的数字信号处理(DSP),其中现场音频系统通常将延迟限制到不超过约10毫秒。当然,如果系统以毫秒为单位响应,我们可能使用长度只有几微秒的输入脉冲。
It's pretty intimidating to see people worrying about latencies in the low microseconds; I'm considering FastDB for digital signal processing (DSP), where live audio systems generally limit latency to no more than about 10 milliseconds. Of course, if a system responds in milliseconds, we might use input pulses of only a few microseconds in length.
没有提到什么系统用于250K查找/ s,50K插入/ s。但是,这是一个积极的迹象。
There's no mention of what system was used for the 250K lookups/s, 50K inserts/s. Still, it's a positive sign.
这篇关于有没有人有FastDB(C ++内存数据库)的任何经验?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!