You don't have to ask column name every time. As long as you know what
column names are (select statement you know, right?) you can get
column values by index. And this will have the same performance as
requesting all values by tuple (someone will have get all values and
insert into tuple anyway) except that there should be some routine of
copying tuple from SQLite-owned memory to your application memory.
Pavel
On Thu, May 21, 2009 at 4:44 PM, rajyalakshmi bommaraju
<rbommar...@yahoo.com> wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
