I have a table of 10 million records with 25 fields in it. I have used Apache Ignite’s SQL driver to store the table in the cache. To retrieve them I’m using the same to query those data. But it’s much slower than retrieving from key-value. Why?
This is my implementation of fetching the data from ignite server: