Have anyone had experience about one connection with multiple statement handle: one for selection and one for deletion. Is there any problem in this case. Thanks, JP
----- Original Message ---- From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, April 28, 2008 9:31:17 AM Subject: Re: [sqlite] One connection with 2 statement handle. I would like to clarify on this locking. So if I have one connection and mulitiple statements then there is no locks in this cases regardless what are the statement operations. Thanks, JP ----- Original Message ---- From: Alex Katebi <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, April 28, 2008 8:44:02 AM Subject: Re: [sqlite] One connection with 2 statement handle. Does this mean that if I have one connection and multiple statements operating on a in-memory table within a single thread no statement will lock out another? In other words locks will not be used? On Sat, Apr 26, 2008 at 7:40 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi, > One connection(sqlite3 *pDb) uses by multiple statements > handle(sqlite3_stmt). > So one connection is used by two multiple statements concurrently one for > insertion and one for selection. Is that ok. > > Have any one experienced this situation. > Thanks, > JP > > > > >____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users