Unfortunately all of the columns are represented in a grid that users can choose to sort on any column, although they are less likely to sort on certain columns, if they do chose to do so then an excessive delay is not really acceptable.
Currently I create ascending and descending indexes for each column individually i.e. create index if not exists name_a on table(name asc) create index if not exists name_d on table(name desc) etc. The data is entered in order for the primary index File size varies from case to case but typically prior to indexing it is about 300MB and with indexes 600MB. Ill have a look at FTS as there are other benefits to using that. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
