Joshua Grauman wrote: > would it make sense to split the table into two tables, where the > first column (the ID) is identical, but the first table only has the > first 3 columns and the second table has the rest of the columns. > Would that make reading the smaller table with only the 3 columns > noticably faster (due to less page faults/etc.)?
Yes, but you can get the same effect by creating a covering index, i.e., an index that contains these three columns: <http://www.sqlite.org/queryplanner.html#covidx> This index can be used for queries that scan the entire table, or that do searches on the leftmost column(s) of the index. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
