Our latest product Pulse is for displaying real-time interactive data direct from any database. To get most benefit, the underlying databases need to be fast (<200ms queries). For our purposes databases fall into 2 categories: Really really fast, can handle queries every 200ms or less and seamlessly show data scrolling in All Other Databases. The […]
I always like to investigate new technology and this week I found a nice automatic technique for improved cache use that I had previously seen some people manually write. Consider a database query with three steps (three SQL SELECTs), some databases may pass results of each step to temporary tables in main memory. When the […]
Often at the start of one of our training courses I’m asked why banks use the Kdb Database for their tick data. One well known reason is that kdb is really fast at typical financial time-series queries (due to Kdbs column-oriented architecture). Another reason is that qSQL is extremely expressive and well suited for time-series […]