Re: [sqlite] Fw: Question about reading all database data into memory

2009-05-21 Thread Pavel Ivanov
ame,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: Ques

Re: [sqlite] Fw: Question about reading all database data into memory

2009-05-21 Thread Jay A. Kreibich
ll. Want to guess how it works? Function calls in and of themselves aren't that expensive. -j > --- On Thu, 5/21/09, Pavel Ivanov <paiva...@gmail.com> wrote: > > From: Pavel Ivanov <paiva...@gmail.com> > Subject: Re: [sqlite] Fw: Question about read

Re: [sqlite] Fw: Question about reading all database data into memory

2009-05-21 Thread rajyalakshmi bommaraju
> 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?

Re: [sqlite] Fw: Question about reading all database data into memory

2009-05-21 Thread Pavel Ivanov
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 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

[sqlite] Fw: Question about reading all database data into memory

2009-05-21 Thread rajyalakshmi bommaraju
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