Re: [sqlite] Clone SQLite databases

Could there be a different page_size, resulting in differing amounts of 'wasted' space? Check with "PRAGMA page_size;" or sqlite3_analyzer program. Thanks Steve csabi81 wrote: > I have made .dump for each database, original and clone, and saved into > separated files. Than compare them. >

Re: [sqlite] Sqlite Endianness

But please don't do this! The resulting database files will NOT be sqlite database files. You won't be able to look at them on other systems (or even using the 'real' library on the same system). Thanks Steve Shane Harrelson wrote: > If you're really serious about storing your data in a

Re: [sqlite] What is quicker?

D. Richard Hipp wrote: > On Jun 4, 2008, at 7:13 AM, Derrell Lipman wrote: > >> On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]> >> wrote: >> >>> Let me strongly reiterate that you look into using the new R-Tree >>> virtual table available for SQLite. R-Trees are