Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Michael Russell wrote: > > 1) The break seems to have happened between 1.0.81.0 and 1.0.82.0. > There was a change in System.Data.SQLite disposal behavior in that timeframe, namely using the new sqlite3_close_v2() API; however, everything [now] conforms to the IDisposable interface semantics and

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Thanks Joe. A couple of follow-up items: 1) The break seems to have happened between 1.0.81.0 and 1.0.82.0. 2) Do Entity Framework team members read this list? -- Michael Russell MTI Film, LLC michael.russ...@mtifilm.com http://www.mtifilm.com/ Providence, RI 02906 USA +1 (401) 831-1315 On

[sqlite] compiling for WP8

Hi, I'm working on compiling for Windows Phone. Are there any helpful notes? In particular, I'm stalled at the missing 'rc' (resource compiler) in the WP8 developer command prompt. Thanks, tim ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] special aggregate feature vs query optimization

On 1/10/2013 12:04 PM, Eduardo Morras wrote: Select max(x), y from t will return 2 colums and n rows Not true. The query uses an aggregate function, so it will return one row per group. There's no GROUP BY clause, so the whole table is one group. Ergo, this query will always return exactly on

Re: [sqlite] special aggregate feature vs query optimization

On 10 Jan 2013, at 5:39pm, Simon Davies wrote: > SQLite version 3.7.11 2012-03-20 11:35:50 Your test is good but the way this worked changed recently. Can you download an up-to-date version of the shell tool from and try on that version ? Simon. _

Re: [sqlite] special aggregate feature vs query optimization

On 10 January 2013 17:04, Eduardo Morras wrote: > On Thu, 10 Jan 2013 14:53:52 +0100 > E.Pasma wrote: > >> Hello, >> >> A query of the form: "SELECT max(x), y FROM table" returns the value >> of y on the same row that contains the maximum x value. > > True > >> I just want to point to a construct

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Michael Russell wrote: > > It's hard for me to tell that, but what I did was to use your > "testlinq.exe" program as follows: >0) Did "build.bat ReleaseNativeOnly x64" to generate SQLite.Interop.dll >1) Load SQLite.NET.2010.sln into VS2010. >2) Set build to "Debug / Mixed Platforms" >

Re: [sqlite] special aggregate feature vs query optimization

On Thu, 10 Jan 2013 14:53:52 +0100 E.Pasma wrote: > Hello, > > this mail is about the aggregate feature that was unveiled in the > release log of version 3.17.11, http://www.sqlite.org/releaselog/3_7_11.html > : > > A query of the form: "SELECT max(x), y FROM table" returns the value > o

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

On 01/10/2013 10:13 PM, Michael Schlenker wrote: Am 10.01.2013 15:31, schrieb Dan Kennedy: On 01/10/2013 07:11 PM, Michael Schlenker wrote: Hi everyone, [snip] I'm pretty sure there was no DELETE for the missing object, but want to verify what happend by comparing the WAL files. Now i check

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

On 10 Jan 2013, at 3:13pm, Michael Schlenker wrote: > So this is a sure way to corrupt the database if the shm code gets an > outdated but not corrupted copy of the -shm file from the OS/filesystem > and additional writes are done. > > Ok, so it seems i should implement some really strict asser

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Am 10.01.2013 15:31, schrieb Dan Kennedy: > On 01/10/2013 07:11 PM, Michael Schlenker wrote: >> Hi everyone, >> [snip] >> I'm pretty sure there was no DELETE for the missing object, but want to >> verify what happend by comparing the WAL files. >> >> Now i checked the wal with the tool/showwal.c pr

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

On 01/10/2013 08:44 PM, Michael Schlenker wrote: Am 10.01.2013 14:23, schrieb Clemens Ladisch: Michael Schlenker wrote: I'm trying to track down some lost commits [...] The sqlite db file and WAL/SHM files are on some automounted linux SAN filesystem (probably NFS beneath it)

Re: [sqlite] How to decrease IO usage

On 9 Jan 2013, at 10:59pm, Bebel wrote: > Now my problem is that my limitation for increase my latency is on the > amount of IO ops perform by the databases. In fact, sqlite make a lot of > random IO on my disks (many hundred) and this increase my disk latency. > > I made a test on a empty data

Re: [sqlite] Change in behavior between 1.0.79.0 and1.0.83.0 in System.Data.SQLite

Hello Joe, It's hard for me to tell that, but what I did was to use your "testlinq.exe" program as follows: 0) Did "build.bat ReleaseNativeOnly x64" to generate SQLite.Interop.dll 1) Load SQLite.NET.2010.sln into VS2010. 2) Set build to "Debug / Mixed Platforms" 3) Add Projects "S

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

On 01/10/2013 07:11 PM, Michael Schlenker wrote: Hi everyone, I'm trying to track down some lost commits for SQLite 3.7.7.1 via the APSW Python wrapper. Pagesize etc. are all left at defaults for the APSW wrapper. The following probablematic scenario: The sqlite db file and WAL/SHM files are o

[sqlite] special aggregate feature vs query optimization

Hello, this mail is about the aggregate feature that was unveiled in the release log of version 3.17.11, http://www.sqlite.org/releaselog/3_7_11.html : A query of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value. I just wan

Re: [sqlite] How to decrease IO usage

On 1/9/2013 5:59 PM, Bebel wrote: I'm working with a lot of sqlite base (many million), but they are very small, 2000 entries for the bigger. In this base, I create 6 tables, but I mostly work on just one of them. My structure are very simple, I stored varchar and blob. Looks like you are usin

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Am 10.01.2013 14:23, schrieb Clemens Ladisch: > Michael Schlenker wrote: >> I'm trying to track down some lost commits [...] >> The sqlite db file and WAL/SHM files are on some automounted linux SAN >> filesystem (probably NFS beneath it) > > says: > | WAL does not

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Michael Schlenker wrote: > I'm trying to track down some lost commits [...] > The sqlite db file and WAL/SHM files are on some automounted linux SAN > filesystem (probably NFS beneath it) says: | WAL does not work over a network filesystem. Also read

Re: [sqlite] How to decrease IO usage

Increase your cache size? Default is 2000*page_size http://www.sqlite.org/pragma.html#pragma_cache_size -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Bebel Sent: Wednesday, January 09, 2013 5:00 PM To: sqlite-users@sqlite.

[sqlite] How to decrease IO usage

Hi there, Let me explain you my problem. I'm working with a lot of sqlite base (many million), but they are very small, 2000 entries for the bigger. In this base, I create 6 tables, but I mostly work on just one of them. My structure are very simple, I stored varchar and blob. My amount of inse

[sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

Hi everyone, I'm trying to track down some lost commits for SQLite 3.7.7.1 via the APSW Python wrapper. Pagesize etc. are all left at defaults for the APSW wrapper. The following probablematic scenario: The sqlite db file and WAL/SHM files are on some automounted linux SAN filesystem (probably N