CODEWITHSUNDEEP
javasqlsqlite
user3074909
user3074909

Reputation: 51

Can't access table while inserting data

When I add a million rows to one table in the database I am unable to access a different table while the insertion is still in progress. Is it possible to get access in this time? I use BEGIN; and COMMIT; to speed up the process a little bit but it still takes 20 - 30 seconds.

Upvotes: 0

Views: 53

Answers (1)

laalto
laalto

Reputation: 152907

No.

sqlite locks the entire database when an exclusive transaction is ongoing.

If you need concurrency, move the other table to another database. Or switch to another database engine that has been designed to support concurrent access better.

Upvotes: 2

Related Questions