Re: [sqlite] Performance tuning for Insert and select operations

On Fri, 31 Aug 2007 09:34:18 +0530, you wrote: >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 single >transaction commit) is taking 4.609000 sec. >50,000 selects from Table ( ha

Re: [sqlite] Performance tuning for Insert and select operations

--- 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

Re: [sqlite] Performance tuning for Insert and select operations

ubject: [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 takin

[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 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)