> When we do "execQuery": > 1. Does sqlite fetches complete result of query and keep it in separate memory > 2. OR Does sqlite fetches result of query in chunks, when we use > "sqlite3_step" and keep it in separate memory > 3. OR Does sqlite fetches records one by one, when we use "sqlite3_step"
Number 3 is how SQLite works, no matter if you have in-memory or on-disk database. And probably even as Marian pointed out it doesn't really "fetch", it just remembers location in the database page (from database page cache) where necessary row is located and actually "fetches" data when you call sqlite3_column(). Pavel On Thu, Jan 13, 2011 at 5:42 AM, Sunil Bhardwaj <sbhard...@ipolicynetworks.com> wrote: > Hi > > > Let me rephrase my question. > > We are using in-memory db. > > When we do "execQuery": > 1. Does sqlite fetches complete result of query and keep it in separate memory > 2. OR Does sqlite fetches result of query in chunks, when we use > "sqlite3_step" and keep it in separate memory > 3. OR Does sqlite fetches records one by one, when we use "sqlite3_step" > > Please help us to understand, how can we use it efficiently. > > Thanks > Sunil Bhardwaj > Ext. 1125 (0120-2567001) > 9818868910 > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ian Hardingham > Sent: Thursday, January 13, 2011 4:07 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How SQLite manages result of a SELECT query? > > That seems like kind of a broad question. > > On 13/01/2011 10:33, Sunil Bhardwaj wrote: >> Hi >> >> Please help us to understand, how SQLite manages result of a SELECT query: >> - We are using in-memory db, >> - >> - When we do "execQuery", what operations are internally done in SQLite >> >> Thanks >> Sunil Bhardwaj >> Ext. 1125 (0120-2567001) >> 9818868910 >> >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Madhurima . >> Sent: Thursday, January 13, 2011 3:30 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] partitioning SQLite database >> >> I am working on embedded system and the device has linux kernel with sqlite >> database. Wanted to know if the sqlite database can be partitioned with >> secure and normal partitions. >> >> How can the encryption be achieved for sqlite database file in linux. >> >> >> -----Original Message----- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin >> Sent: Thursday, January 13, 2011 3:18 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] partitioning SQLite database >> >> >> On 13 Jan 2011, at 6:08am, Madhurima . wrote: >> >>> Is it possible to have partition in SQLite database? >> The word 'partition' is used for more than one meaning. You might be >> talking about spreading the data about, or grouping results from a SELECT >> command. Could you give an example or a reference to documentation ? >> >> Simon. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> "DISCLAIMER: This message is proprietary to Aricent and is intended solely >> for the use of the individual to whom it is addressed. It may contain >> privileged or confidential information and should not be circulated or used >> for any purpose other than for what it is intended. If you have received >> this message in error, please notify the originator immediately. If you are >> not the intended recipient, you are notified that you are strictly >> prohibited from using, copying, altering, or disclosing the contents of this >> message. Aricent accepts no responsibility for loss or damage arising from >> the use of the information transmitted by this email including damage from >> virus." >> _______________________________________________ >> 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 > > _______________________________________________ > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
