Hello,
Now I'm using SQLite v3.4.2 in my Mobile Device(ARM9-200Mhz, 8MB SRAM) and it works fine. But when I updated to SQLitev3.5.3 this time I am facing problem. Please let me know why it is happening. This is my test source in MS's VisualC++ 6.0 (Console application). http://cfs7.blog.daum.net/upload_control/download.blog?fhandle=MElCMXRAZ nM3LmJsb2cuZGF1bS5uZXQ6L0lNQUdFLzAvMC56aXA=&filename=0.zip&filename=SQL3 53_VC6.zip Problem 1. when I use "mem1.c" and use "Order By", it require more memory than I expected. It seems has same problem when I use "mem3.c". I want use less than 1MB. So I set "SQLITE_DEFAULT_CACHE_SIZE=800" and "SQLITE_DEFAULT_TEMP_CACHE_SIZE=200". Problem 2. When I use "mem3.c" and set "SQLITE_MEMORY_SIZE = 1024000", "insert" was failed. Please help am I setting ANY WRONG PARAMETERS. Best Regards, Jang
