Hi, This mail is a bit lengthy. I thank you in advance for your patience and help:-).
Here we go...... I need to port sqlite to a platform where the RAM size is too small about 512kb. For that I need to tune sqlite to make its footprint, heap and stack memory as small as possible. As said in the documentation on sqlite.org, I could get the least possible footprint of 170KB with all the optional features turned off. My Analysis of heap and stack usage is as follows. Stack memory is consistent about 9-10K Heap memory is highly variant on size and number of records. I tried modifying the page size(SQLITE_DEFAULT_PAGE_SIZE and SQLITE_MAX_PAGE_SIZE ) in pager.h from 512 to 2048 but found no reduction in heap size. With indexes on every column(searched), the following is the heap size for different database operations on a database with 100 records and 6 tables with an avg of 10 to 15 fields each. Operation MAX Heap Average Heap(Bytes) insertion 85939 24166 deletion 397834 76541 Selection of all records 246973 79075 Update of all records 249808 196334 It seems quite a huge heap consumption. Are these numbers as expected? Is there a way that I can reduce these numbers in the range of 40-50kB by any means (including accessing pattern). I would like to know the reason for high heap consumption for deletion operation. Thanks in advance. Kalyani ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] **********************************************************************