I have everything working now, and am just tidying up. I want to add indexes, if needed, but this is for a cellphone app, and I'm worried about using up space, particularly when the data is unlikely to be more than a couple thousand rows in total. But there is a query that might be slow without indexes, so it's kind of a catch-22.
The query looks like this: select distinct * from tbl where a <> 0 order by a desc, b desc, c desc, d desc limit 2; where a, b, c, and d are all type INTEGER. What is the overhead in O notation for adding an index to a column in SQLite? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
