Re: [sqlite] Queries on SQLite
SQLite does not create the thread. The application creates the thread and then runs the async writer on that application created thread. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Christian Smith > Sent: Friday, 15 June, 2012 04:01 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Queries on SQLite > > On Thu, Jun 14, 2012 at 06:27:17AM -0400, Richard Hipp wrote: > > On Thu, Jun 14, 2012 at 2:41 AM, vallur raghava reddy < > > vallur.raghavare...@gmail.com> wrote: > > > > > > > 2. Does SQLite create a any threads? If YES, how many will be created? > > > > > > > SQLite does not create threads. > > > > Except when the asynchronous IO module is used: > http://www.sqlite.org/asyncvfs.html > > This VFS module will create a single background IO thread. > > Christian > ___ > 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
Re: [sqlite] Queries on SQLite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/06/12 03:01, Christian Smith wrote: > Except when the asynchronous IO module is used: > http://www.sqlite.org/asyncvfs.html > > This VFS module will create a single background IO thread. No it doesn't. You have to create the thread for the background I/O and then call sqlite3_async_run() in it. See the compilation and usage section of the documentation page you linked to. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk/bUP0ACgkQmOOfHg372QQQFQCcDtuK047xMmBHq3wCdeMaGvMH /EsAoJxLDesoPoTDIKL5jp7lxkbqqPuR =//2U -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Queries on SQLite
On Thu, Jun 14, 2012 at 06:27:17AM -0400, Richard Hipp wrote: > On Thu, Jun 14, 2012 at 2:41 AM, vallur raghava reddy < > vallur.raghavare...@gmail.com> wrote: > > > > 2. Does SQLite create a any threads? If YES, how many will be created? > > > > SQLite does not create threads. > Except when the asynchronous IO module is used: http://www.sqlite.org/asyncvfs.html This VFS module will create a single background IO thread. Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Queries on SQLite
On Thu, Jun 14, 2012 at 2:41 AM, vallur raghava reddy < vallur.raghavare...@gmail.com> wrote: > Hi, > I have few queries on SQLite. I have listed them below, please go > through them and answer. > > 1. Is SQLite POSIX compliant? > I'm not sure what this question is asking. SQLite works on POSIX systems. It uses only POSIX interfaces on those systems. What does it mean for an ANSI-C code library to be "POSIX compliant"? SQLite also runs on Windows, OS/2, SymbianOS, QNX, and a host of other non-POSIX systems. Does that make it non-POSIX compliant? > 2. Does SQLite create a any threads? If YES, how many will be created? > SQLite does not create threads. > > Previously I have sent few questions and the response was really good. I > really appreciate that. Please reply the same for above questions. > > Thanks > > Raghava Reddy > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users