Convert your sql to sql Statements. run sqliteanalz and see which all columns are to be indexed.
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: venkata ramana <[EMAIL PROTECTED]> Date: Friday, August 31, 2007 9:34 am Subject: [sqlite] Performance tuning for Insert and select operations > Hi, > > I am using SQLite 3_3_17with the default configuration of SQLite. > Using Windows XP C++ API. > 50,000 inserts into Table (with primary key and no other index as > singletransaction commit) is taking 4.609000 sec. > 50,000 selects from Table ( having 1,00,000 rec with primary key > and no > other index) , query using primary key is taking 8.751000 sec. > I have to achieve insertion bench mark of nearly 50,000 insertions > in 1.5 to > 2 sec. > I have to achieve selection bench mark of nearly 50,000 selections > in 1.5 to > 2 sec. > Please tell me if it is possible to tune Sqlite to achieve this > performance. > Regards, > Ramana > **************************************************************************** > **************************** > This e-mail and 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! > > > > -------------------------------------------------------------------- > --------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------- > --------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
