Re: [sqlite] about the apparently arriving soon "threads"

>On Tue, Apr 8, 2014 at 11:00 PM, big stone wrote: >> Hi, >> >> I did experiment splitting my workload in 4 threads on my cpu i3-350m >to >> see what are the scaling possibilities. >> >> Timing : >> 1 cpu = 28 seconds >> 2 cpu = 16 seconds >> 3 cpu = 15 seconds >> 4 cpu = 14

Re: [sqlite] Establishing a connection and downloading tables from an SQLite server

> I guess that using a command line interface program could work. I used it > for a local database and it worked perfectly, but the problem is that I'm > not sure how to do it when the original file is in a remote server. Again, > maybe I'm missing something obvious and if I am, I'm sorry. > I

Re: [sqlite] about the apparently arriving soon "threads"

On Tue, Apr 8, 2014 at 11:00 PM, big stone wrote: > Hi, > > I did experiment splitting my workload in 4 threads on my cpu i3-350m to > see what are the scaling possibilities. > > Timing : > 1 cpu = 28 seconds > 2 cpu = 16 seconds > 3 cpu = 15 seconds > 4 cpu = 14 seconds >

Re: [sqlite] LINQ - SQLite | Compact Framework 3.5?

Ryan Finnesey wrote: > > Has Devart http://www.devart.com/company/ taken over the LINQ to SQLite > project? > No idea, I've never had any dealings with them. Also, I have not heard of the "LINQ to SQLite" project, per se. > > I am looking for a way to add support for LINQ and SQLite in

Re: [sqlite] Establishing a connection and downloading tables from an SQLite server

Hello, design your own RPC layer thru https with all the credentials you need. Best. On Mon, Apr 7, 2014 at 12:21 PM, Armando Gonzalez wrote: > Donald: > > I appreciate the response. > > I guess that using a command line interface program could work. I used it > for a

Re: [sqlite] about the apparently arriving soon "threads"

On 8 Apr 2014, at 8:00pm, big stone wrote: > I did experiment splitting my workload in 4 threads on my cpu i3-350m to > see what are the scaling possibilities. > > Timing : > 1 cpu = 28 seconds > 2 cpu = 16 seconds > 3 cpu = 15 seconds > 4 cpu = 14 seconds > > Analysis :

Re: [sqlite] about the apparently arriving soon "threads"

Hi, I did experiment splitting my workload in 4 threads on my cpu i3-350m to see what are the scaling possibilities. Timing : 1 cpu = 28 seconds 2 cpu = 16 seconds 3 cpu = 15 seconds 4 cpu = 14 seconds Analysis : - sqlite is such a small foot-print in memory, it is really scaling well with the

Re: [sqlite] Is there a way to load a blob from the shell?

On Mon, Apr 7, 2014 at 4:58 PM, Petite Abeille wrote: > > On Apr 8, 2014, at 1:46 AM, Andreas Kupries wrote: > >> Most generally, a website to show off any kind of contribution to >> sqlite, be it custom function, virtual table, virtual

[sqlite] More context on parse error

I've mentioned before on the list that a bit more context in parse error messages would be helpful in our application. I hacked something quick that seems to work for us, posting it in case anyone else finds it useful or would like to improve on it.

Re: [sqlite] How to handle simultaneous reads/writes in SQLite

On 8 Apr 2014, at 3:20pm, David Brown wrote: > It's my understanding that any number of reads can be going on > simultaneously (from other threads even) but ONLY ONE thread can write at a > time. Is this correct? Right. > Also, how would one handle multiple

Re: [sqlite] How to handle simultaneous reads/writes in SQLite

On 4/8/2014 10:20 AM, David Brown wrote: It's my understanding that any number of reads can be going on simultaneously (from other threads even) but ONLY ONE thread can write at a time. Is this correct? This is correct. -- Igor Tandetnik ___

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

On 8 Apr 2014, at 2:22pm, Jens Miltner wrote: > So what would cause SQLite not being able to use one of the two indexes I > have? First, run "ANALYZE". Then run "EXPLAIN QUERY PLAN ". This may give you some clues about how SQLite is understanding your SELECT requirements when

[sqlite] How to handle simultaneous reads/writes in SQLite

Hi I'm new here, I'm also new to databases in general. My question is about how SQLite handles multiple simultaneous reads and writes. It's my understanding that any number of reads can be going on simultaneously (from other threads even) but ONLY ONE thread can write at a time. Is this

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

Jens Miltner wrote: > apart from a JOIN statement, there is no WHERE clause relating to table "a" For purposes of optimization, an inner join is the same as a WHERE clause. > LEFT JOIN a ON a.b_id=b.id AND a.identifier=x.identifier An outer join, however, requires that the left table is used

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

On Tue, 08 Apr 2014 15:22:18 +0200 Jens Miltner wrote: > CREATE INDEX a_idx1 ON a(b_id); > CREATE INDEX a_idx2 ON a(identifier, b_id); > > both of which could be used according to the JOIN statement and/or > the CASE statement (if this part would use an index at all). > > > I

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

Am 07.04.2014 um 18:42 schrieb Richard Hipp : > On Mon, Apr 7, 2014 at 11:51 AM, Jens Miltner wrote: > >> We get an sqlite3_log() message with errorCode 284 and message "automatic >> index on ...". >> I assume this is some performance penalty warning, but I have

Re: [sqlite] Crashing in sqlite3_free->sqlite3MallocSize() function

You should provide a test case to get help from other people ! On Tue, Apr 8, 2014 at 11:28 AM, Ashok Pitambar wrote: > Hi All, > > While executing query multiple times in a loop I encountered crash in > function sqlite3MallocSize() which is called from sqlite3_free().

[sqlite] Crashing in sqlite3_free->sqlite3MallocSize() function

Hi All, While executing query multiple times in a loop I encountered crash in function sqlite3MallocSize() which is called from sqlite3_free(). I see that an invalid memory 0x is being freed here instead of address range 0x81BD0C98-0x81BD0E50. Any idea what is happening here? stack

Re: [sqlite] Is there a way to load a blob from the shell?

At 08 Apr 2014 09:53 +0100, Tim Streater wrote: > > On 08 Apr 2014 at 00:13, Richard Hipp wrote: > > > On Mon, Apr 7, 2014 at 6:56 PM, Keith Christian > > wrote: > > > >> > >> However, on production *nix machines, the path to the SQLite 'sar' > >>

Re: [sqlite] Is there a way to load a blob from the shell?

On 08 Apr 2014 at 00:13, Richard Hipp wrote: > On Mon, Apr 7, 2014 at 6:56 PM, Keith Christian > wrote: > >> >> However, on production *nix machines, the path to the SQLite 'sar' >> will probably have to be absolute, or else the native 'sar' (System >>