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
