OK, got it. Thanks! BR Rick
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, May 12, 2010 10:01 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] DB files are different between PC sideandinstrumentside. On 12 May 2010, at 2:39am, Lei, Rick (GE EntSol, SensInsp) wrote: > Another question is if Sqlite uses at least 1 page for each table and index, does it means if the contents in a table doesn't fill 1 page, Sqlite will not request a new page when operating this table. Is it right? Any extra data -- updating a field or adding a row -- might request a new page until SQLite can successfully delete the old data. And don't forget that SQLite maintains a journal file. Almost any change to the database may temporarily ask for more journal space even if the new data is smaller than the old data. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users