Daily Archives: 2010-09-18

SQLite index optimization

Learned one fascinating fact tonight: when creating indices for a table in SQLite the order in which the columns are indexed seems to have a huge impact on performance. On the table in question, which has 20.2 million rows, one … Continue reading

Posted in EN, Programming, Software | Leave a comment