Pavel, you're great! There's nothing better than to just ask the right people. Calling sqlite3_close after the mentioned function solved the problem. By the way I got something like this: > - 0x0005e688 Free 28 was never alloc'd 0x400f3ec4 > - 0x0005e750 Free 29 was never alloc'd 0x400f3ec4 > - 0x0005e768 Free 30 was never alloc'd 0x400f3ec4 > - 0x0005e788 Free 31 was never alloc'd 0x400f3ec4 and so on, but I think there's nothing to worry about. My database has the page_size of 1024. I see now I have probably missed some basic rules of using SQLite. I just created a Database class with constructor opening a database connection and storing a sqlite3* pointer and destructor closing this connection. In this situation every Database::execute call produced, as you said, not freed cache. It seems to be the cause of all my problems with "leaks". Is lowering the PRAGMA cache_size a good way to fix this? My database works on embedded platform with 64MB of RAM.
Thanks again, cheers, Maciej _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

