Hello, Our application does a lot insert and delete, it is strange that in one rather low-end machine, the performance by using temp table is around 7 times faster than using normal table. but in one high-end machine, the performance of those both are about equal.
how is the "temp table" implemented by sqlite? is it simply a session issue or it is doing less disk I/O? it seems that "temp table" uses both memoy(cache) and disk when it is doing insert/delete, its disk utility is almost as high as using normal table as the application does massive deletes/inserts. Br,Kai
