In Memory SQL type tables
I am looking for a way to implement In Memory Tables. I have a some data that I need to access quite fast, but I also need the functionality that an SQL table offers me. Eg Querries for searching, etc. So is there any way I can load an SQL type table into memory and then Querry that table?.
I could implement, say some dyanamic data stuctures and then write some operations for them, but that seems to be a lot of work. Moreover I would have to make a lot of changes in my existing code. What I am looking for here is that, in the normal case when my prog executes a Querry from a table, that table is on the disk and so the Querry takes time. I was tinking if there was some way to load that same same table into memory and then Querry it from there.
Thanks in anticipation.