Is SQL Fast Enough for Tick Data?
Article by Steven Graves, McObject CEO and co-founder
Published on November 5, 2015, reprinted with permission from TabbFORUM
Trading systems have eschewed SQL due to its perceived performance latency and unpredictability, in favor of more labor-intensive, lower-level programming languages (namely q and C/C++) for database operations. But is SQL really too slow for trading systems?
The fact that a SQL DBMS now “owns” nine of the 17 STAC-M3 tests demonstrates that SQL, in and of itself, is not a performance bottleneck. And this stands to reason. SQL (like q) is merely a language; it is the implementation of the language, and characteristics of the underlying DBMS, that determine performance.
So what SQL DBMS characteristics contributed to the record-setting STAC-M3 results?
• Columnar layout
• Distributed Query Processing
Please use the following link to open the article.
Learn more about eXtremeSQL.
eXtremeSQL database interface is a high-performance implementation of the SQL database programming language for eXtremeDB.
The eXtremeDB Time Series Database
eXtremeDB for High Performance Computing, the low latency database technology for Big Data and Capital Markets.
eXtremeDB for Financial Systems
eXtremeDB for HPC time series database delivers the most powerful solution for managing market data while maximizing productivity through open, developer-preferred languages, making it the ideal database for financial systems.
The eXtremeDB STAC Summaries
eXtremeDB has proven time and time again that SQL can set, then break, it’s own records for tick data management. Review our test results.
We invite you to evaluate the latest version of McObject’s eXtemeDB for HPC software, ideal for cloud, analytics and financial systems.