Thanks for the reply dan. You probably don't "need" clustered indexing as such, but this would be > > the kind of case where it provides some advantages. You can get the same > effect in SQLite by including all the data columns in your index > definition. > > Unfortunately, because I will be making very frequent inserts (every 10-100ms), an index spanning all columns would be much too expensive and would hurt insert times.
Julian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
