12-23-2009, 09:39 PM
|
|
Banned
|
Join Date: Feb 2007
Posts: 1,002
|
|
|
If you are working with an unindexed schema, the queries will use a lot of CPU. Transactions have nothing to do with it. Certainly queries are unindexable.
I have no idea if the /stats are accurate, but be aware that SQLite doesn't perform any magic if you don't tell it to.
If you post your schema/queries I can give some pointers. |
|
|
|