RE: [sqlite] (select *) VS (select column1, column2 ...)

--- "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

RE: [sqlite] (select *) VS (select column1, column2 ...)

nd 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 only include the co

Re: [sqlite] (select *) VS (select column1, column2 ...)

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,

RE: [sqlite] (select *) VS (select column1, column2 ...)

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