Thanks, I understand.
I will run my VACUUM far less often and try and look at some locking
options.
Regards,
Ben
D. Richard Hipp wrote:
On Wed, 2005-06-01 at 17:16 +0100, Ben Clewett wrote:
Some extra information:
I also note I run a VACUUM every 50 minutes. Could this result in the
"database schema has changed" message I sometimes see? Possibly one
thread accessing database during VACUUM?
Yes. Strange though it may seem, VACUUM changes the
schema.
What happens is that VACUUM moves tables and indices
around inside the file. Even though the schema as seen
by us humans remains the same, the way the schema is
implemented on the inside does change. And it is the
inside implementation that the SQLITE_SCHEMA error
cares about.
