[sqlite] Improving SQLite performance over a network

Hello, I am using SQLite in a Windows environment. The file storing the database is on a Windows 2008 server.All other file access to this server is reasonably fast. However, when doing simple SELECTS and INSERTS/UPDATESit is noticeably slower on a network. I am talking about 50 records. Now I

[sqlite] SQlite database access over wireless network

Hello, I am trying to troubleshoot a problem that I'm having with a program usingSQLite over a wireless network.? I know that wireless networks can havetheir own sets of issues that cause database access problems. What is happening is that something that takes 1 or 2 seconds on a wirednetwork

[sqlite] Including PRAGMA statements on connection string

Hellom, I am using the c# variant of sqlite (system.sqlite.data.org) and am using a connection string similar to this: public static string OMconnectionString = "datasource=database.db; Default Timeout=20; PRAGMA busy_timeout = 600; PRAGMA synchronous=Off"; I then use the following statements to

Re: [sqlite] Network and concurrency

avin <slav...@bigfraud.org> wrote: On 26 Nov 2014, at 4:20pm, Mike McWhinney <elja...@sbcglobal.net> wrote: > Are there any other PRAGMA or connection string > statements that can help with this concurrency issue? If you haven't set a busy timeout then SQlite won't retry wh

[sqlite] Network and concurrency

Hello, I am continuing to have sporadic problems with SQLite and a WinForms application that I'm developing. The program is a Winforms app using the System.Data.SQLite class. I am running this off a network. There are a small number of users which read and write to a database stored on a

Re: [sqlite] Locking errors on network

I am using Sqlite.NET client in C#. How would I go about defining a sqlite busy timeout handler? Thanks Mike On Monday, November 10, 2014 1:35 PM, Tim Streater <t...@clothears.org.uk> wrote: On 10 Nov 2014 at 18:22, Mike McWhinney <elja...@sbcglobal.net> wrote: > So S

Re: [sqlite] Locking errors on network

:41 AM, Mike McWhinney wrote: > Please let know if there are any other solutions to this database > locking problem as used on a network. Yes. Do not do it. See the FAQ: https://www.sqlite.org/faq.html#q5 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYE

[sqlite] Locking errors on network

Hello, I continue to have "database is locked errors" when running an application which accesses a SQLite dabase on a network. I have tried many of the connection string options: pooling, changing default time out. I just recently tried a block of code which does a BeginTransaction and

[sqlite] Random locking errors using Sqlite.NET

Hello, I continue to have random errors on SQLite.NET (ADO provider). I have the version 3.8.6 (System.Data.SQLite.dll with version 1.0.94.0). I am getting random locking errors during the execution of my program. The program resides on a network and each client has a mapped share with full

Re: [sqlite] Fw: Database is locked exceptions

<slav...@bigfraud.org> wrote: On 30 Oct 2014, at 4:13pm, Mike McWhinney <elja...@sbcglobal.net> wrote: > I have continued to receive the locking erros. The latest connection string I > have as follows: > > public static string OMconnectionString = "URI=file:osle

[sqlite] Fw: Database is locked exceptions

meout when the database gets locked? Thanks Mike On Wednesday, October 29, 2014 5:26 PM, Mike McWhinney <elja...@sbcglobal.net> wrote: I will let you know if this fixes the problem. So far I have not had any locking issues. I will see tomorrow when it receives more usage and tr

[sqlite] Database is locked exceptions

Hello, I have written a program in C# Visual Studio Winforms. In general the SQLite database is working quite well. However, lately we have been plagued with database locking errors: Here is the exeption: database is locked database is locked at