On Thu, Aug 7, 2014 at 5:51 AM, Paul Dillon paul.dil...@gmail.com 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 table
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
On Fri, 8 Aug 2014 11:14:29 +0200, Giuseppe Costanzi
giuseppecosta...@gmail.com 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
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
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
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
best
On 8 Aug 2014, at 8:11am, Paolo Combi paolo.co...@ipratico.it 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 -close
On Fri, Aug 8, 2014 at 9:11 AM, Paolo Combi paolo.co...@ipratico.it 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 little. Hope
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
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
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
On 8 Aug 2014, at 7:35pm, Errol Emden eem...@hotmail.com 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);
On 8 Aug 2014, at 7:59pm, Simon Slavin slav...@bigfraud.org 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
WHERE
On Aug 8, 2014, at 8:35 PM, Errol Emden eem...@hotmail.com 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
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
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
On 8 Aug 2014, at 7:35pm, Errol Emden eem...@hotmail.com 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.
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 is
On Friday, 8 August, 2014 13:46, Petite Abeille petite.abei...@gmail.com said:
On Aug 8, 2014, at 8:35 PM, Errol Emden eem...@hotmail.com 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...
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
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
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 doing
On Wed, 6 Aug 2014 20:56:24 -0400
Richard Hipp d...@sqlite.org 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 southerners prefer to
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
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...
Try this:
SQLiteConnection connection = new SQLiteConnection(
FullUri=file::memory:?cache=shared;);
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
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
27 matches
Mail list logo