On 18 December 2017 at 06:59, Dinu <dinumar...@gmail.com> wrote: > Richard Hipp-3 wrote > > Can you try this: > > (1) BEGIN TRANSACTION > > (2) DROP all indexes from the table > > (3) Do the DELETE operation > > (4) CREATE all indexes again > > (5) COMMIT > Thanks Richard, as mentioned earlier, any structure change is unacceptable > due to concurrent reader clients. >
I'm not sure what you're worried about? Dropping and recreating identical indices within a transaction won't cause a visible structure change to concurrent readers -- that's the point of a transaction. Unless perhaps those readers are soooo old they're using the deprecated sqlite3_prepare rather than prepare_v2, and fall over when encountering SQLITE_SCHEMA? -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
