inserts make sqlite write large amounts of data to disk, deletes make it (quickly) mark affected pages as unused.
On 6/21/06, Insun Kang <[EMAIL PROTECTED]> wrote:
Hi. I tested big deletes performance and big insert performance on a Windows CE device in various cache size configurations. ( 1MB, 100KB, 50KB ) Insert 3000 records performs within 23sec, 43sec and 61sec, with respect to each cache size configuration. However, delete 1000 records among 3000 records performs within about 0.4secs for all cache size configurations. Why does delete operation outperform insert operation? and how come the delete operation is independent of cache size? I think the updating indices costs are almost same in both insert and delete operations. Can anybody explain the reason? -- Insun Kang
-- Cory Nelson http://www.int64.org