Re: [sqlite] Bug: PRAGMA busy_timeout outputs the value, screws up html

Kees Nuyt writes: > > On Tue, 24 Dec 2013 22:55:32 -0500, dmitry babitsky > wrote: > > >*bug description:* > >Using PRAGMA busy_timeout outputs the value which in case of html output > >screws up the display. > >To be more precise, it creates an extra row/recordset

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

Ed Tenholder wrote: > > I have never used a profiling tool. Have VS 2010 installed. > Depending on which edition of Visual Studio 2010 is installed, you may be able to simply use their managed code profiling tools. Thankfully, these tools are fairly straightforward to use and produce nice

[sqlite] Significant Performance Problem with System.Data.SQLite.

I have never used a profiling tool. Have VS 2010 installed. A quick web search shows several available free tools. What do you recommend for VS 2010 and SQLite? Are you able to run the application with profiling enabled to determine

Re: [sqlite] Sqlie from c#: encoding bug?

Dear Pepijn, thank you very much for your answer, you are saying a lot of right things. I believe that your most important suggestion is to use the hex function. I didn't know this sqlite command andI I will try it soon. In the meantime I solved my problem Jand I wrote a post also here:

Re: [sqlite] sqlite error

I didn't set any timeout value. It was fine with delete/insert/update/select queries. Suddenly, started giving sqlite error with error code 1. On Tue, Jan 21, 2014 at 9:03 AM, d b wrote: > Hi all, > > sqlite throws error code 1 while sqlite busy with read/write

Re: [sqlite] sqlite error

On 21 Jan 2014, at 5:03am, d b wrote: > sqlite throws error code 1 while sqlite busy with read/write operations. > what could be the reason. But, I could not reproduce this with test > program. what is the best way to handle sqlite error. Is it like sqlite > abort case? I