> From: d...@sqlite.org
> Date: Thu, 13 Jan 2011 07:59:11 -0500
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How SQLite manages result of a SELECT query?
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
