I tried this, using plain ordinary Windows applications instead of services. One ran through ten insertions, and the other performed one insertion per second overnight. This morning, the 10-insertion application was taking 4.9 megabytes of memory, while the all-night version took 5.6 megabytes. If I can get my service down to that rate of growth, I'll be happy.
RobR ________________________________ From: Radcon Entec <[email protected]> To: General Discussion of SQLite Database <[email protected]> Sent: Tue, April 27, 2010 2:25:56 PM Subject: [sqlite] Hypothetical memory consumption question Greetings! I have a hypothetical question. Assume I have the simplest possible SQLite database on a disk file: a single table with a single column. Now assume that I have a Windows service that opens the database when it starts, and leaves it open forever. The service has a loop that is executed once a second. The loop increments a counter that starts at 0. If the counter is less than 10, then a query of the form "INSERT INTO table_name (column_name) VALUES (counter)" is built, and sqlite_exec() is called to execute it. After 10 seconds, the service continues to run, but the insertion is never perfored again. Now assume I have a second Windows service identical to the first, except that the maximum value of the counter is 10,000. Now assume I start both services at the same time. Then, three hours later (>10,000 seconds), I use TaskManager to see how much memory the two services are using. Will they be consuming the same amount of memory? RobR _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
