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" > SQLite computes one row at a time, as you call 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
