Hi I am using SQLite on MVL OS for ARM processor based embedded platform. I am using SQLite version 3.3.13. We use SQLite APIs for DB operation. I am facing following issue.
While testing I observed INSERT and UPDATE command is taking more time than SELECT queries. For example one select query is taking 1 to 2 mili sec where as one INSERT or UPDATE takes 40 to 100 mili secs. We are seeing very high latency for write queries. We tried some performance enhancement flags and PRAGMA settings. Is there any performance enhancement settings in SQLite? Or any known issue? Thanks & Regards Suresh *********************** Aricent-Restricted *********************** "DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus."