Re: [sqlite] why sqlite engine gets slower when executing transactions

On 4 May 2010, at 1:54pm, Romica Dascalescu wrote: > We are using sqlite to generate a schema with ~600 tables + 500 indexes + 50 > views and some other triggers. Apparently your developer is some kind of Autistic data-warehousing genius who can keep 600 tables with different columns straight

[sqlite] why sqlite engine gets slower when executing transactions

Hi, We are using sqlite to generate a schema with ~600 tables + 500 indexes + 50 views and some other triggers. Our module: - Opens a transaction - Creates a table - Inserts some rows - Commits the transaction It seems this takes a lot of time to execute (