Re: [sqlite] SQLite Optimization

On 3 Dec 2009, at 6:26pm, mr_orange wrote: > I am trying to optimize the speed of my SQLite transactions. The goal is to > beat query and insertion times that we have with MS SQL. I guess there are 2 > main issues: > > 1) The query times are faster when I do simple select statements on a large >

[sqlite] SQLite Optimization

I am trying to optimize the speed of my SQLite transactions. The goal is to beat query and insertion times that we have with MS SQL. I guess there are 2 main issues: 1) The query times are faster when I do simple select statements on a large amount of data. I start to run into trouble when I get