Second process has bigger database file, so most probably more data will be cached and so more memory consumed. If both processes are working with the same database, and after second process have finished inserting first process executes "SELECT * FROM table", and fetches all 10,000 records from that table, then memory consumption of both processes should be even.
Pavel On Tue, Apr 27, 2010 at 2:25 PM, Radcon Entec <[email protected]> wrote: > 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
