Hi there,
I am a huge SQLite fan and am very curious as to why the following would happen. Essentially I have a "queue implementation" using SQLIte in WAL mode and it is working really well. However, at runtime if I watch the Task Manager in windows as thousands of messages are sent to it, the memory just grows and grows and grows. The moment I take out the queue stuff in my program the memory is fine. I have the database with the following settings: PRAGMA journal_mode=wal PRAGMA wal_checkpoint PRAGMA synchronous=normal PRAGMA temp_store=memory Is there something I could be doing wrong here? As an example here is some code that PEEKS a message off the queue: I am using the following sequence when I run queries on the database: sqlite3_prepare_v2 sqlite3_bind_parameter_index sqlite3_step sqlite3_finalize If you have any ideas why you think the memory is growing at a rapid rate please let me know? Many thanks ;-) Lynton _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
