Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Gilles Ganault wrote: > > Got it: "Dependency Walker" shows that the (no-)bundle versions rely > on MSVCR110.DLL, which is part of the "Visual C++ Redistributable for > Visual Studio 2012 Update 1", available here: > > www.microsoft.com/en-us/download/details.aspx?id=30679 > > Once installed,

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Fri, 19 Apr 2013 23:42:19 +0200, Gilles Ganault wrote: >Thanks the tip. More testing in the IDE shows that it works OK even >when editing the PATH, and I can no longer trigger the "Unable to >load DLL 'SQLite.Interop.dll': The specified module could not be >found.

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 23:46:58 -0400, markus diersbock wrote: >Since it worked, you can move the files to any final folder, and add a >reference to System.Data.SQLite.dll > >And add your folder to PATH, to find SQLite.Interop.dll Thanks the tip. More testing in the IDE shows

Re: [sqlite] Potential problem in SQLite 3.7.16.2

FWIW: The following script demonstrates the problem: CREATE TABLE t1(x INTEGER, y INTEGER); CREATE INDEX t1xy ON t1(x,y); CREATE INDEX t1y ON t1(y); CREATE TABLE t2(x INTEGER PRIMARY KEY, y INTEGER); CREATE TABLE t3(x INTEGER PRIMARY KEY, y INTEGER); CREATE INDEX t3y ON t3(y); .wheretrace off

Re: [sqlite] Variable-length records

On Fri, Apr 19, 2013 at 08:19:57AM +0200, Hick Gunter scratched on the wall: > IIRC temporary tables are limited to the connection that creates them. Yes. So are in-memory databases. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Fri, Apr 19, 2013 at 9:17 AM, Mario M. Westphal wrote: > Hi, thanks. > > But I'm not sure that I understand you correctly. > > Is this behavior considered as something that needs to be looked at by the > SQLite Team to restore the original performance, or is this how "it is"

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Hi, thanks. But I'm not sure that I understand you correctly. Is this behavior considered as something that needs to be looked at by the SQLite Team to restore the original performance, or is this how "it is" now and I have to find a work-around for good (e.g. applying your suggestion with

Re: [sqlite] Potential problem in SQLite 3.7.16.2

On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > We can provide a sample database etc. on request. > Can you send the database to my private email, please? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Potential problem in SQLite 3.7.16.2

The change in behavior occurs with http://www.sqlite.org/src/info/38852f158a If you need a work-around, change INNER to CROSS in the queries and the old query plan will be restored. On Thu, Apr 18, 2013 at 3:27 AM, Mario M. Westphal wrote: > This is a SQL Script > > > /* >

Re: [sqlite] Questions about Timeline

On Thu, Apr 18, 2013 at 12:51 PM, Aimard Janvier wrote: > > > Hello, > > I would like to know how to access more than 200 entries (previous months > or years) on your Timeline. > Look on the URL and find the place where is says "n=200". Change the 200 to whatever number you

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Hi, Celemens I created the requested log data by running the same operations in my application, once compiled with the 3.7.15.1 version (OK) and once with the 3.7.16.2 (BAD performance). The query plans are quite different. 1. --- The query my application runs for this test INSERT INTO

Re: [sqlite] Variable-length records

Thank You -- View this message in context: http://sqlite.1065341.n5.nabble.com/Variable-length-records-tp68277p68300.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Questions about Timeline

Hello, I would like to know how to access more than 200 entries (previous months or years) on your Timeline. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Variable-length records

IIRC temporary tables are limited to the connection that creates them. -Ursprüngliche Nachricht- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Donnerstag, 18. April 2013 19:30 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Variable-length records On 18 Apr