chetana bhargav wrote:
If any one can explain me correctly what sqlite3_prepare does apart from preparing the statement, and does prepare means generating the byte codes necessary.
Chetana,
sqlite3_prepare does nothing other than preparing an SQL statement, and
yes, that does inclu
chetana bhargav wrote:
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
-Chetan.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 9/1/06, John Stanton wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores
Jay Sprenkle wrote:
On 9/1/06, John Stanton <[EMAIL PROTECTED]> wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores prepared statements. It has restrictions which may make it
unsuitable for general purpose applications, but could be the answer
this user is look
> I'll check my assumptions when I get some time but I thought
> interpreting an sql statement cost only a few milliseconds of time. I
> would think saving it to a rotating disk would be worse. It would cost
> on average a half disk rotation of latency to read it. Flash memory
> has no rotational
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
> > It does make a difference with embedded deivces, where both speed and
> > memory constraints matter a lot.
>
> I'll check my assumptions when I get some time but I thought
> interpreting an sql s
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi All,
I know that we can use sqlite3_prepare, proabably my perception is wrong,
when I say sqlite3_prepare I am thinking the opcodes which ever is necessary to
run the query is created upon this call, and we can keep filling the various
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
I'll check my assumptions when I get some time but I thought
interpreting an sql statement cost only a few milliseconds of time. I
would
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
-Chetan.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 9/1/06, John Stanton wrote:
> I believe that Dr Hipp has available a special version of Sqlite which
> stores prepared statements. It
Hi All,
I know that we can use sqlite3_prepare, proabably my perception is wrong,
when I say sqlite3_prepare I am thinking the opcodes which ever is necessary to
run the query is created upon this call, and we can keep filling the various
values by just resetting the prepared statements an
On 9/1/06, John Stanton <[EMAIL PROTECTED]> wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores prepared statements. It has restrictions which may make it
unsuitable for general purpose applications, but could be the answer
this user is looking for.
For the ben
Jay Sprenkle wrote:
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi,
Is there any way to pre compile some of the prepared statements
during compile time. I am having 4 tables of which two tables doesn't
create any triggers/joins. I am basically trying to speed up the
queries on t
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi,
Is there any way to pre compile some of the prepared statements during
compile time. I am having 4 tables of which two tables doesn't create any
triggers/joins. I am basically trying to speed up the queries on these tables
(as they a
chetana bhargav wrote:
> Is there any way to pre compile some of the prepared statements during
> compile time. I am having 4 tables of which two tables doesn't create any
> triggers/joins. I am basically trying to speed up the queries on these tables
> (as they are most frequently used). I am
13 matches
Mail list logo
