On 11/10/05, Huang Tao <[EMAIL PROTECTED]> wrote: > 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?
Can you move your temp tables to in an in-memory(RAM) database?
