maybe rename and recreate the database with "insert from" the remaining
tables would be faster,
and give the benefit of a vacuum also?
On 09/09/2016 13:14, Венцислав Русев wrote:
On 09/09/2016 12:49 PM, Bhavesh Patel wrote:
I have a 4GB SQLite database (currently using SQLCipher for
encryption). I have created a physical table in the SQLite DB which
has approx 200000 rows x 183 columns. When I am trying to delete the
table. Sqlite is taking up a lot of time to delete the huge table.
I tried drop table and also delete all the rows - in both the cases
it takes up 1-2 minutes approx.
during the process of delete/drop is running, if I try to connect I
randomly get database lock error.
I would like to know if there is any optimized way to delete such
huge table or any other ways to run drop/delete but allow other users
to connect and use the database or can avoid waiting of other connect
to the DB?
Thanks in advance
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I don't know if this will work for you, but can't you delete 1000 rows
then another 1000 ... until the table is empty.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users