Re: [sqlite] sqlite tuning for db writes?

Guy Hindell wrote: The majority of SQL commands issued are INSERTs and DELETEs, and so it is these that I would like to optimise. Performance at the moment is respectable, although I would prefer to see DELETEs go a bit faster. In my application I use transaction for multiple inserts and

[sqlite] sqlite tuning for db writes?

Hi I'm relatively new to sqlite and this list but I have recently used it (v3.2.7) as an alternative to the db backend of an application which previously used SQLServer or Access as part of a proposed port to Unix/Linux. So far so good - the app works just as it did before with SQLServer.