Which is a better in-memory technology for fast computations on big data - Kdb or Ignite? Ignite provides caching to store huge amount of data and we can perform SQL operations on it. Kdb is also an in-memory database which provides very fast computation on time-series data. In my use case, I don't need to update data. I just need to use the historical data on-the-fly for some computations. I tried out myself and Kdb gave much better performance numbers as compared to Ignite. I am new to Ignite though, so I might be missing something here. So, just wanted to confirm which technology is better in the use case mentioned. There has been no direct comparison provided anywhere on internet.
Can somebody please through some light on this?
KDB is a column-store database. Ignite is row-store. So the performance depends on your data layout and the kind of computations that you run.
If you provide the code, Ignite community may help with performance advice.