--- "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> I wanted to know how SQLITE works internally. Assume I am doing
Try using the EXPLAIN command on your queries:
EXPLAIN SELECT foo from bar;
EXPLAIN SELECT * from bar;
http://www.sqlite.org/lang_explain.html
> But if SQLITE uses some othe
let me understand what exactly
happens.
Regards,
Phani
-Original Message-
From: Tom Briggs [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 6:41 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] (select *) VS (select column1, column2 ...)
In general, it's best to
Using SELECT * will be slower. How much slower depends on your table.
Why don't you test it and see?
--- "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> Assume I have a table with 40 columns. I would like to know the
> difference between
>
> Select * from table
>
> Select column1, column2, colu
ly the columns you
need is more efficient. No, I don't think you'll notice much of a
difference in terms of performance.
-T
> -Original Message-
> From: B V, Phanisekhar [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 31, 2007 7:33 AM
> To: sqlite-users@sqlite.org
Assume I have a table with 40 columns. I would like to know the
difference between
Select * from table
Select column1, column2, column3 from table
While doing SQLITE3_PREPARE, will both take same amount of time?
While doing SQLITE3_STEP, will both take same amount of time?
5 matches
Mail list logo