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
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
"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
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
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.
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
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
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 are most frequently used). I am looking for ways so
9 matches
Mail list logo