On 26 Nov 2009, at 2:04pm, Thomas Lenders wrote: > I am using SQLite on a mobile device. > > I have this one table which has only one field, but I need to search in > the table very quickly. > When creating an index on this field the size of the database is doubled > - which makes sense. > > However, is there some way to implement this scenario more efficiently > using SQLite ?
When you talk about searching, are you talking about searching in an ordered way (e.g. all the records in alphabetical order) or are you matching on content using something like LIKE '%fred%' ? For the LIKE matching, no INDEX is used. If you have just one column in the field, and don't need it indexed, do you really need SQL at all ? Could you not just store the data as a text file ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users