[EMAIL PROTECTED] wrote: > > ----- Original Message ---- > > From: Joe Wilson <[EMAIL PROTECTED]> > > To: sqlite-users@sqlite.org > > Sent: Monday, June 11, 2007 8:36:32 PM > > Subject: Re: [sqlite] Database replication question > > > > > > Large bulk inserts with more than one index (implicit or explicit) > > is not SQLite's strong suit. > > > > If you search the mailing list archives you'll find a few suggestions: > > > > - "BEGIN EXCLUSIVE" (or is it "BEGIN IMMEDIATE"?) on the > > database file and then copy the file over - fastest way > > What do you mean by "copy the file over"? A straight copy of the > binary content of the file? If so, I can't really do that because > the version of sqlite are potentially different on the two machines.
The binary file format for SQLite version 3 is (usually) the same for all versions going back to version 3.0.0. The exception is if you use some of the newer features introduced in later versions, then earlier versions of the library might not be able to read the file. But your schema does not appear to be using any advanced features, so I think you will always be OK. One of the key features of SQLite is that we work really hard to preserve backwards compatibility of both API and file format. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
