On 5 Aug 2010, at 10:03pm, Sam Roberts wrote: > But do you think the section would make the counting faster? I think > I'd have to get the row counts like this, which would still do the > slow full table scan: > > select section, count(*) from my_table where name like '%e%' group by > section;
But 'group by section' can profit from the index on the section column so it should be faster. As with all these things, the suggestion is to try it and see. You should try six or seven different solutions including shuffling columns and indexes before you settle on the one that will be in your final code. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
