"weiyang wang" <[EMAIL PROTECTED]> wrote: > hi, > > i am working on the sqlite evaluation for mobile phone. and now i am facing > the issues of memory footprint. > > according to the documents, three parameters are used to control the memory > footprint: default_cache_size, cache_size and page_size. > > i set them like this: > default_cache_size =1: > cache_size =1: > page_size=1024 > > so the footprint for caching tables should be 1K. is it correct?
The minimum cache size is 10. If you set the cache size to something smaller than 10, it defaults to 10. Note also that the cache size can increase above the limit you set if a complex query requires simultaneous access to more pages that the cache is defined to hold. So the cache size is not a hard limit. > > under this condition (default_cache_size =1, page_size=1024), i measured the > memory handling of sqlite and the result showed that the total memory > footprint is about 20K. > > is it the smallest footprint of Sqlite? if not, how to shrink it to a couple > of Ks? > 20K is already pretty small for an SQL RDBMS, don't you think? How much more of a miracle are you looking for here? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
