Raheel Gupta wrote: > When I delete just 2-3 rows, that page is not reused for the new data > which will be inserted in the future.
SQLite's tables are B-trees, sorted by the rowid. Your new data will probably get an autoincremented rowid, which will be appended at the end of the table. A page gets reorganized only when about 2/3 is free space. > How should I get SQLIte to use the free space within a partially used page > when rows from that page have been deleted. VACUUM (which needs lots of free disk space, and should not be executed too often). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
