[sqlite] .NET System.Data.SQLite, how trap SQLITE_BUSY_SNAPSHOT (WAL) and retry

Hi, I am using WAL. If I use a new db connection for every write (as usually suggested practice) and connection pooling is enabled, my writes are quite a bit faster. Good so far. However, I also see some db locks occurring, specifically: (517) SQLITE_BUSY_SNAPSHOT For some reason, the

[sqlite] System.Data.Sqlite.dll v93 performance issues...

Guys, I do not know if this is the right forum, but we found a reproducible perf issue with System.Data.Sqlite.dll. A simple query like this: Select * from Dxlog where ContestNR = 0 order by contestnr, TS limit 24 offset 143098 Takes about 60ms to fetch the first record from the

Re: [sqlite] DMV available in Sqlite?

: Andreas Hofmann [mailto:andreas.hofm...@ku7t.org] Sent: Thursday, July 24, 2014 12:33 PM To: 'General Discussion of SQLite Database' Subject: DMV available in Sqlite? Hi, I know how to use SQL server DMV for analyzing query performance. I am wondering if something similar to the MS SQL

[sqlite] DMV available in Sqlite?

Hi, I know how to use SQL server DMV for analyzing query performance. I am wondering if something similar to the MS SQL Server DMV is available for Sqlite (http://msdn.microsoft.com/en-us/library/ms188754.aspx)? Anyone? Thanks Andy ___

[sqlite] Fine tuning table indexes

Hi, I would like to fine tune table indexes. I want to make sure I got indexes for the columns or combined columns of all (most) where clauses. The issue is that the application builds dynamic SQL strings all over the place and it may not be easy to find them all without reading the code very

[sqlite] Need pointers for better build integration and support of schema updates

Sorry if some of these are no brainers, I am a sqlite newbie with some MS SQL experience. Our application uses 3 Sqlite dbs and System.Data.Sqlite.dll (dropped by installer). Functionality allows users to start a new instance of one of the databases at run time. Hence we ship empty databases

Re: [sqlite] Could not load file or assembly 'System.Data.SQLite.dll'or one of its dependencies on Windows XP. Ideas?

this is happening? Thanks Andreas -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andreas Hofmann Sent: Wednesday, November 13, 2013 7:59 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Could not load file

Re: [sqlite] Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies on Windows XP. Ideas?

Andreas -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andreas Hofmann Sent: Wednesday, November 13, 2013 5:19 PM To: sqlite-users@sqlite.org Subject: [sqlite] Could not load file or assembly 'System.Data.SQLite.dll' or one of its

[sqlite] Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies on Windows XP. Ideas?

Deploying the same app on W7 32, W7 64, and XP 32. Using XCOPY deployment. W7 are fine, in XP it complains about this: System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies. The specified module could not be found. File name: