Mayank Kumar (mayankum) wrote: > will the memory used by sqlite keep on increasing, if we don't > finalize at all during the life time of the db, as we do more insert/ > delete/replace operations ?
Every prepared statement needs some memory (but only a small amount). As long as you are using these statements, there is no problem. Anyway, prepared statements do not occupy 86 MB; this sounds like the page cache. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users