--- venkata ramana <[EMAIL PROTECTED]> wrote: > 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 single > transaction 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.
With the right hardware you can achieve this performance. ____________________________________________________________________________________ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------