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

Reply via email to