You asked if they "might not be functionally identical". The speedup and file size impacts can be considered functional attributes. Disregarding those, and ignoring the possibility that somebody might consider the return from<code> select last_insert_rowid(); </code>or queries like<code> select * from info where rowid > 0; </code>to be "functional", the two DBs should produce the same response to queries except for uncontrolled result set ordering.