Ad 2) Yes, this is expected. SQLite uses file locking to implement transactions.
Ad 1) Using WAL mode, readers can read data as it was before the write transaction started. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von king3306 Gesendet: Mittwoch, 02. Mai 2018 17:14 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] sqlite3 not support write and read at the same time? HI every one i use sqlite3 3.22.0 verison on embeded arm9 system when i insert a lot of data like this begin_transaction sqlite3_prepare_v2(); for(i = 0;i<2040;i++) { sqlite3_bind_text(); sqlite3_bind_blob(); sqlite3_step(); sqlite3_reset(); sqlite3_clear_bindings(); } sqlite3_finalize(stmt); commit_transaction(); insert data about 15s but when i read read bettwen 15s ,i cant read data from database 1、how can i solve this problem? 2、Is this a normal behavior ？ -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
