In Memory Tables

Hi,

How can I implement In Memory Tables? I have a some data that I need to access quite fast, but I 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 stucture and then add operations for it, but that seems to be a lot of work. 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 thinking if there was some way to load that same same table into memory and then Querry it from there.

Thanks in anticipation.

Consider using SQLite, a self-contained, zero configuration SQL database engine written in C that can be embedded into C++ programs. SQLite supports in-memory databases.

Thanks man, that was just what I was looking for. Thanks a lot :)