Hello !  

Would be nice if sqlite provide a way to create indexes in parallel, I mean
when working with big tables and creating several indexes the time spent
scanning the whole database/table is considerable and it's the same for each
"create index", we could have a big time/cpu/disk seek saving if we could
create several indexes at the same time:  

CREATE INDEXES ON big_table index_1(name), index_2(title), index_3(parent),
index_4(city, country);  

Cheers !

Reply via email to