Hi Jay, thanks for your help,
/ > Does anyone know if SQLite stores additional unique internal
/>/ > information such as timestamps etc. that would affect this, and />/ > if so could these "additional to the data" variable features be />/ > disabled in any way? // />/ SQLite files do contain some metadata like row numbers and internal page />/ hashes, but nothing like timestamps unless the programmer generated them />/ in software. /
While there are no timestamps, SQLite does keep a number of counters and other meta-data in the file header page that are not directly under programmer control. This includes a "change counter" that gets incremeted with every write. http://www.sqlite.org/fileformat.html
<http://www.sqlite.org/fileformat.html> But if data was added exactly in the same way/order shouldn't the counters all count to the same end result if the process was repeated at a later time on a another machine? Thanks again for your time, David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users