If there are x columns in the row , now I have to keep saying getnext
columnname,get next column value for that name for x times. instead I get
values into tuple in one call.
-Raji
--- On Thu, 5/21/09, Pavel Ivanov <paiva...@gmail.com> wrote:
From: Pavel Ivanov <paiva...@gmail.com>
Subject: Re: [sqlite] Fw: Question about reading all database data into memory
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Thursday, May 21, 2009, 11:33 AM
Why do you expect performance improvement in your approach as opposed
to implemented now?
Pavel
On Thu, May 21, 2009 at 1:56 PM, rajyalakshmi bommaraju
<rbommar...@yahoo.com> wrote:
> I did not get any reply so adding bit more explanation for what I need.
>
> In a C program, I am trying to read data from database. I use
> sqlite3_prepare_v2 to execute "Select * from abc", sqlite3_step to get a row,
> and sqlite3_col_name,sqlite3_col_val to get column values. I read columns
> one by one for each row. Instead I would like to read (x,y,z) { example sake,
> assume that x,y,z columns exist} from a row at a time into variables as a
> tuple. Can I do that?
>
> Is there a way, I can attach tuple to the database query and get the data as
> an array of tuple? Is it possible.
>
> Experts, please throw some light on this.
>
> Thanks
> Raji
> 5/20/09, rajyalakshmi bommaraju <rbommar...@yahoo.com> wrote:
>
> From: rajyalakshmi bommaraju <rbommar...@yahoo.com>
> Subject: [sqlite] Question about reading all database data into memory
> To: sqlite-users@sqlite.org
> Date: Wednesday, May 20, 2009, 9:16 PM
>
> HI,
>
> . If I have to read all the database data into memory, I needed to execute
> sqlite3_prepare_v2 statement,and then sqlite3_step to access the rows, and
> processing each row to get the rows content. This does not look efficient.
> Is there any other way to do this?
>
> Thanks
> Raji
>
>
>
> _______________________________________________
> 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
