Hello: I run sqlite in embedded system which use nand flash. So I have to reduce write count. Save index in master database will cause much write. I try to dynamic create index on temp database. But the speed is not very well. example: create table employee (id int primary key not null, name); insert 10000 record to table; create index temp.idx_name on employee (name); create index will use 24.519761 sec
with gprof, I see most time was used in sqlite3BtreeInsert, which called 10001 times. Anyone can give me suggestion to improve the speed? CPU: 96MHz mips32 Memory: 16M File System: tmpfs (so all run in memory) SQLite: 3.2.7
