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

2007-09-03 Thread Joe Wilson
--- "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 ...)

2007-09-03 Thread B V, Phanisekhar
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 ...)

2007-08-31 Thread Joe Wilson
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 ...)

2007-08-31 Thread Tom Briggs
icient. 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 > Subject: [sqlite] (select *) VS (select

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

2007-08-31 Thread B V, Phanisekhar
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?