Re: [Lazarus] RE : RE : SQLite performance problem. Simple query takestoolong.

2011-07-29 Thread Howard Lee Harkness
On Fri, Jul 29, 2011 at 1:42 PM, Ludo Brands wrote: > I traced through TSqlQuery.Close and there isn't happening a lot, except for > cleaning up prepared statements and cursors. And that is where your direct > BEGIN/COMMIT could very well confuse sqlite. > sqlite3_finalize(fstatement) is used to u

[Lazarus] RE : RE : SQLite performance problem. Simple query takestoolong.

2011-07-29 Thread Ludo Brands
> Thank you for your reply. I found it very interesting. I > switched the code that I posted to the following (I > refactored this so that I could call from several different > places, for inserts, updates, and > deletes): > > procedure TfrmMain.ExecSQL(sql:string); > begin > FormDatabase.