Hi, I used to think that getting selected fields from a relational DB is faster than getting all fields, so I used to carefully selected only those that I needed for a particular task. However, this is time-consuming (for a developer) and error prone. So, I've relaxed my rules on occasions. And also, in some presentation by the lead (I think) Drupal developer I heard him say that we shouldn't bother with that and just use the *. Now, it is possible that I misunderstood him or forgot what really happened because it's been a long time ago, and maybe his recommendation applied to Drupal specifically and maybe only in some situations... I don't know for sure.
I've just tested with a query I was working on with an SQLite management tool and noticed that selecting all fields took at least *twice as long* as selecting only two, and I don't have a huge number of columns (only 18). And I am not sure if I was testing SQLite or this particular tool. (It is possible that allocating memory for more fields is very stressful for this tool.) So, I want to ask those who are more experienced with SQLite and also with other relational DBMSs than I am: is it generally significantly faster to select only what's needed than selecting all fields? Roman _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
