Database in Trading part 2

156
TLDR; ArticDB looks to be the best current option.
CSV - Simplest, slowest, largest and no data types can lead to type errors when loading.
SQL Database - typically transactional row store (OLTP), slow for analysis (OLAP), difficult to shard and parallelize workloads over clusters.


While MongoDB proved the fastest to read and write end-of-day OHLC (Open, High, Low, Close) data — the SQL solutions were 1.5 × to 3 × slower — in terms of costs MongoDB was definitely the most expensive due to its commercial licensing costs.

免責聲明

這些資訊和出版物並非旨在提供,也不構成TradingView提供或認可的任何形式的財務、投資、交易或其他類型的建議或推薦。請閱讀使用條款以了解更多資訊。