I am running into issues where I am running out of memory on my embedded app. I have stored 10K records in a table. There is an index on a key field and a sort field. An external program needs to reconcile its data with the data in this table. It does so 200 records at a time. The code I am using is: Sprint(buffer, "SELECT * FROM tbl_Log where key > %ld and key < %ld order by key asc", id, id + 200);
The query takes about 3 seconds to run which is acceptable. The external app sends an id of 0 and increments according to what is received from the query. It is expected to run 50 times to get the 10K records. After each query, the memory usage jumps. After about 10 queries I am out of RAM. Any ideas on how I can keep the RAM usage stable and low? I am doing the finalize on the statement after the looping over the records so I do not think there is a memory leak there. Any help is appreciated. Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
