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? 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? really appreciate your help. wang