Thanks. I will try it. Do you have any idea for my question 2??
2. How to release the unused page in the memory database? just like the vacuum in the file database.
Thanks. On 12/24/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
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] -----------------------------------------------------------------------------
