--- "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
In general, it's best to only include the columns you need in the
SELECT clause. And not just with SQLite - that's the best approach when
dealing with any database. SQLite is a bit more forgiving because
there's no network between the client and the database to slow things
down, but that's st
4 matches
Mail list logo