RE: [sqlite] sqlite performance questions.

2006-10-18 Thread Robert Simpson
> -Original Message- > From: Mohd Radzi Ibrahim [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 3:23 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite performance questions. > > Hi, > Could you tell me what breaks the transaction?

Re: [sqlite] sqlite performance questions.

2006-10-18 Thread Mohd Radzi Ibrahim
Hi, Could you tell me what breaks the transaction? Is create table/index within transaction breaks it? best regards, Radzi. - Original Message - From: "Isaac Raway" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 2:07 AM Subject: Re: [sqlite] sqlite perfo

Re: [sqlite] sqlite performance questions.

2006-10-18 Thread Isaac Raway
I'm going to agree with Robert here, I have an application that makes heavy use of large blob of text in a sqlite database. Performance was unbearable, wrapping even small sets of operations in transactions greatly improved the performance. I don't have numbers, but suffice it to say that it went

RE: [sqlite] sqlite performance questions.

2006-10-18 Thread Robert Simpson
> -Original Message- > From: Andrew Cheyne [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 8:08 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] sqlite performance questions. [snip] > I have then been writing some sample C programs making use > of the C API, > but hav