Re: [sqlite] What am I doing wrong?

Keith...as a neophyte, I am totally blown away by your skill level in SQL and the ease with which you explain its underlying operations. I am extremly impressed by the 'flattening of the query' and its operation...it worked perfectly!!. I am so happy that this forum has persons of your

Re: [sqlite] Need help on SQLite In-Memory Mode

Try this: SQLiteConnection connection = new SQLiteConnection( "FullUri=file::memory:?cache=shared;"); -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.8.6 coming soon

"big stone" wrote... hi Jose, The SQL request with a "in()" that is improved by 5x in the latest beta is of form : select * from a , b where a.field1 in (b.column1, b.column2, b.column3, b.column4, 'fixed value') Hi Big Stone, This is what I am running with an ATTACHed DB as client...

Re: [sqlite] What am I doing wrong?

Leaving out the extra fields the movie table, enforcing referential integrity, and using "same column names" to hold the same data, and declaring the right indexes, you can get a much more efficient solution, both in the expression and the execution: These optimizations are only necessary

Re: [sqlite] SQLite version 3.8.6 coming soon

On Wed, 6 Aug 2014 20:56:24 -0400 Richard Hipp wrote: > > http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm > > > > Two countries divided by a common tongue. > > > Except, I speak Southern English, not British English. And I can > promise you that we

Re: [sqlite] What am I doing wrong?

Keith...thanks vmuch for your insightful and enlightening approach of translating 'in parts'. I am truly indebted to you for your mentoring approach...be well. > Date: Fri, 8 Aug 2014 15:03:13 -0600 > From: kmedc...@dessus.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] What am I

Re: [sqlite] What am I doing wrong?

The SQL script you wrote actually provides the same information as mine - it lists all movies that Julie Andrews is in but it does NOT provide who is the leading actor in each movie, as all names selected is that of Julie Andrews. > Date: Fri, 8 Aug 2014 20:55:55 +0200 > From: luu...@gmail.com

[sqlite] SQLite 3.8.6 beta

A bit thanks to E.Pasma who found a performance regression in 3.8.6, which has now been fixed (with added test cases to prevent a recurrence). Fresh snapshots are now on the download page (http://www.sqlite.org/download.html). Please continue to test the latest snapshots and report any issues you

Re: [sqlite] What am I doing wrong?

On Friday, 8 August, 2014 13:46, Petite Abeille said: >On Aug 8, 2014, at 8:35 PM, Errol Emden wrote: > >> I am to list the film title and the leading actor for all of the films >'Julie Andrews' played in. > >And another one, for diversity's

Re: [sqlite] What am I doing wrong?

>I am to list the film title and the leading actor for all of the films >'Julie Andrews' played in. >The following is structure of the tables used: >movie(id, title, yr, director, budget, gross); >actor(id, name); >casting(movieid, actorid, ord). >The column name ord has a value of 1 if the

Re: [sqlite] What am I doing wrong?

On 8 Aug 2014, at 7:35pm, Errol Emden wrote: > I am to list the film title and the leading actor for all of the films > 'Julie Andrews' played in. You know, one day we should actually solve someone's homework questions. Just to mess with their head. Simon.

Re: [sqlite] SQLite version 3.8.6 coming soon

hi Jose, The SQL request with a "in()" that is improved by 5x in the latest beta is of form : select * from a , b where a.field1 in (b.column1, b.column2, b.column3, b.column4, 'fixed value') ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] In-memory DB slower than disk-based?

Yes Stephen, your description of the locking when writing is pretty much exactly what I'm sure is happening. A couple clarifications though: I have only 20 or 30 threads on the server side. It's the client that has 100 or more threads. And I'm opening all connections to the DB when the server

Re: [sqlite] What am I doing wrong?

On Aug 8, 2014, at 8:35 PM, Errol Emden wrote: > I am to list the film title and the leading actor for all of the films > 'Julie Andrews' played in. And another one, for diversity’s sake… Assuming a slightly different data model: with AndrewsMovie as ( select

Re: [sqlite] What am I doing wrong?

On 8 Aug 2014, at 7:59pm, Simon Slavin wrote: > SELECT leadActor.name, movie.title FROM casting > JOIN actor AS leadActor ON leadActor.id = casting.actorid > JOIN movie ON movie.id = casting.movieid > JOIN actor AS selectedActor ON selectedActor.id = casting.actorid >

Re: [sqlite] What am I doing wrong?

On 8 Aug 2014, at 7:35pm, Errol Emden wrote: > I am to list the film title and the leading actor for all of the films > 'Julie Andrews' played in. The following is structure of the tables used: > movie(id, title, yr, director, budget, gross); > actor(id, name); >

Re: [sqlite] What am I doing wrong?

On 8-8-2014 20:35, Errol Emden wrote: I am to list the film title and the leading actor for all of the films 'Julie Andrews' played in. The following is structure of the tables used: movie(id, title, yr, director, budget, gross); actor(id, name); casting(movieid, actorid, ord). The column

[sqlite] What am I doing wrong?

I am to list the film title and the leading actor for all of the films 'Julie Andrews' played in. The following is structure of the tables used: movie(id, title, yr, director, budget, gross); actor(id, name); casting(movieid, actorid, ord). The column name ord has a value of 1 if the actor

Re: [sqlite] After ANALYZE all has become slow

well, after an intense session of debug, we have come to understand the why of these decreases of performance. In practice in two tables on 40 they missed two indexes on a total of 50. Now adversity has wanted these two indexes to be used more or less by a lot of interrogations. Restored these the

Re: [sqlite] sqlite merge

On Fri, Aug 8, 2014 at 9:11 AM, Paolo Combi wrote: > APP working --> call backup function ->close sqlite-> download sqite -> > reopen sqlite -> APP working > Do you know about http://www.sqlite.org/backup.html? Just in case... Not quite your problem, but related a

Re: [sqlite] sqlite merge

On 8 Aug 2014, at 8:11am, Paolo Combi wrote: > thank you so much for your reply , i'm very interesting about close this > connection under iOS because i work together with the guys that do this app. > our problem is do this : > > APP working --> call backup function

Re: [sqlite] sqlite merge

hello Simon, thank you so much for your reply , i'm very interesting about close this connection under iOS because i work together with the guys that do this app. our problem is do this : APP working --> call backup function ->close sqlite-> download sqite -> reopen sqlite -> APP working

[sqlite] Need help on SQLite In-Memory Mode

‍‍ Hi dear sqlite users, I am using SQLite In-Memory Database in my application. My application is written in C#. I am trying to create an In-Memory Database that can be opened by multiple connections as descripted in this link. What it is the right format of connection string in this

Re: [sqlite] After ANALYZE all has become slow

The default installation on my VPS running the current release of CentOS is pretty old as well. Unfortunately it is kind of difficult to upgrade the version of SQLite (and/or Python) on some Linux distributions because there are other system dependencies on the versions of Python. For

Re: [sqlite] After ANALYZE all has become slow

On Fri, 8 Aug 2014 11:14:29 +0200, Giuseppe Costanzi wrote: sqlite3.sqlite_version >'3.5.9' Version 3.5.9 is more than 6 years old. A lot of optimizations were introduced since that version. Please upgrade and try again. -- Groet, Kees Nuyt

Re: [sqlite] After ANALYZE all has become slow

using putty Linux SRVXXX 2.6.26-2-686 #1 SMP Mon Aug 30 07:01:57 UTC 2010 i686 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes

Re: [sqlite] Improve query performance using a join

On Thu, Aug 7, 2014 at 5:51 AM, Paul Dillon wrote: > 1. Will moving these 8 query fields to a smaller table improve query > performance when joined to the larger table? My logic is that this small > table would only be about 5% the size of the full table, so the full