Imagine the following sequence on a "multi thread shared" connection.
Thread A prepares a SELECT statement Thread A steps the statement a couple of times to retrieve some data Thread B comes along an finalizes the statement What do you propose should happen when thread A tries to step the statement? What if thread A is in the middle of INSERT ... SELECT when B commits? -----Ursprüngliche Nachricht----- Von: NULL [mailto:the-figh...@qq.com] Gesendet: Sonntag, 04. Mai 2014 11:55 An: drh; sqlite-users Betreff: [sqlite] Is it better that sqlite support share One Database Connection In Multithreads? Hi, In sqlite's Document,it's said that any time you can't share ONE database connection across more than one threads.In my mind,this restrict is much bad,expecially for using memory based database. So,can the changes come at next version? Zhouran 05/04/2014 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
