How to make InMemory.db a Memory mapped file and use it as database in MFC

Question

I have to use InMemory.db in my project but the performance is slow the InMemory.db size is 10 MB. Some queries which retrives more than 30000 records take a lot of time. Is their any way i can improve the performance.

How to make InMemory.db a Memory mapped file and use it as database in MFC. An example will be very helpfull?

Answer 1

This size of DB should be fully cacheable on any Windows desktop without you doing any extra work.

Check your SQL and your schema (esp. table indices) before the DB.