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
