Hi, >> First, consider if some combination of those columns constitute a primary key. That would be stronger than a simple index. Does SQLite support multi column primary keys ? Also wouldnt primary keys actually slow down further inserts. I have queries to insert nearly 10000 rows in one second. With larger database multi column primary keys might slow down right ?
>> create /* covering */ index ByDS on map(d, s, n); Creating this index in my DB. It takes time. Its too big you know. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
