Turn off sync using pragma. Build sqlite with appropriate cache and page size suitable to u;r system. use sqliteanalyze and find out the page size. Always use begin and commit/rollback for insert and updates.
Joe& others had provided us with good direction. regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ***************************************************************************************** ----- Original Message ----- From: [EMAIL PROTECTED] Date: Wednesday, July 18, 2007 1:36 pm Subject: [sqlite] performance issue > 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." > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
