Hi,
In my C application, I create a table and insert 32 rows every second.
Each row has about 28KB. Every 5 seconds, it deletes old rows with timestamp
<= current time - PERIOD. I did create an index on the column 'timestamp,'
but I observed that every 5 seconds, cpu usage hits up to 9%. Without index,
cpu usage is just a bit more (10~11%). This doesn't happen when I disable
the delete operations.
My question is: is there a discussion saying that delete in SQLite may use
more cpu usage than others like MySQL? is there a way to fix it? or perhaps
I am just missing something?
Thanks,
WeiHsin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
