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

Reply via email to