Re: [sqlite] On VACUUM I get "constraint failed"

he issue is. > > sqlite> .output db.sql > sqlite> .dump > sqlite> .exit > > sqlite3 -init db.sql test.db > > hope this helps > --preston > > >From: John Duprey <[EMAIL PROTECTED]> > >Reply-To: sqlite-users@sqlite.org > >To: sqlite-users@

RE: [sqlite] On VACUUM I get "constraint failed"

his helps --preston From: John Duprey <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: [sqlite] On VACUUM I get "constraint failed" Date: Thu, 20 Oct 2005 14:01:10 -0400 We have an SQLite database with a table that has about a mill

[sqlite] On VACUUM I get "constraint failed"

We have an SQLite database with a table that has about a million rows. We do a lot of (thousands) of deletes and inserts in this table. Recently, deleting rows has become slow. I assumed the slow down was a result of fragmentation or wasted space due to the deletes. Therefore, I thought vacuumi