Hi All, I am using a memory database in an embedded device with sqlite_3.3.5. For performance consideration, all the database access are running in the SDRAM. I need to perform both CopyFileDBToMemDB and CopyMemDBToFileDB with high performace and less memory used.
My current solution is create schema then insert all data to the destination table. But when I create the index after insert all the data, all the CPU and Memory resource almost exhaust. The problem is 1. Could I perform a page by page copy to reach the synchronization purpose? 2. How to release the unused page in the memory database? just like the vacuum in the file database. Would you please help to tell me how to improve that? Thanks for your great help. Thanks, VK
