This mailing list thread may be helpful: http://www.mail-archive.com/sqlite-users@sqlite.org/msg15902.html
--- PY <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
