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?
Maybe, maybe not. Since the file format specifies meaningful fields only (my guess) it's quite possible that the slack space (meaningless sequences of bytes spread around the DB file) could hold random garbage from memory. I doubt the team would certified that slack space will always contain the exact same data in all configurations, platform, etc.
So unless such formal guarantee comes from the dev team, I wouldn't bet my life on that, even if the exact same platform is being used for DBs X & Y.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
