Hello all, 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 ? It seems like I am storing all data twice and space on mobile devices is rather limited. -- My table: CREATE TABLE [ART] ([artnr] VARCHAR(10) NOT NULL); CREATE UNIQUE INDEX [IDX_ART] ON [ART]([artikelnr] ASC); or CREATE TABLE [ART] ([artnr] VARCHAR(10) PRIMARY KEY NOT NULL); Are both identical in terms of size. Thanks for your help. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users