good point, I was just after some general results, I do take your point
about caching etc. However it is logical to apply UNION ALL if appropriate
in preference to UNION which in this context is a bit lazy. I'm a bit
annoyed I didn't pick up on it myself, but thankful to Igor for
Careful with the timing. You may be looking at OS memory caching the
result set instead of pulling from the drive. For best bets, either re-run
both queries several times, ditch the longest and shortest times, then take
the mean or average times and do the comparison that way.
On Wed, Oct 15,
Nice one. A quick test using 10 lookup trees and the same search criteria:
*Showing rows 0 - 29 (30 total, Query took 0.4838 sec)*
Now with UNION ALL replacing UNION:
*Showing rows 0 - 29 (30 total, Query took 0.2050 sec)*
You weren't kidding about cheaper were you? LOL
On 16 October
Yes, I agree with the general sentiment. It is not exactly the design I
would have chosen either, but it is what exists. Design change is occurring
but for the moment we are stuck with the current schema.
If you cannot change the schemata to be more suitable, then your
> demonstrated queries are
On 2014/10/16 00:05, Michael Falconer wrote:
first off I must start with an apology. I know I'm sort of doing the wrong//...
No need to apologise, this flies quite close to the central theme. Whether you are using SQLite or any other SQL RDBMS, this is
horrible DB design and it is
On 10/15/2014 6:05 PM, Michael Falconer wrote:
Personally, I'd have one set of tables, each with an extra column
containing . Why do you need a separate set of tables, only to
UNION them on every request? Instead of
first off I must start with an apology. I know I'm sort of doing the wrong
thing here as this question is NOT related to sqlite. It is a general SQL
question but I ask it here because I have great respect for the answers and
discussions I have seen on this forum over many years. I rarely
Venkatarangan MJ wrote:
>How do I unsubscribe from the group as I have stopped using SQLITE from quite
>some time now?
Send a message with subject or body 'help' to sqlite-users-requ...@sqlite.org
This is written in the header of each digest; I don't know about
Unrelated to databases, sql, and sqlite but I noticed the poor rating on
sqlite.org of an F:
It would be nice to have a better rating!
On the positive side, oracle.com doesn't even have an SSL for the homepage.
Thanks for your suggestions.
@Mikael I do believe that write caching was disabled on target. However,
enabling lazy data write and data caching didn't make much of a difference.
@Ketil I specified the pragmas before copying by executing the sql statements
"PRAGMA Dest.journal_mode = OFF" and
On Tue, 14 Oct 2014 18:21:27 -0400
Ross Altman wrote:
> Yeah, that's actually a really good point. Oh well, I guess I'll just
> have to hope that people decide to use the database responsibly...
You can advertise your database with the tagline, "Please compute
I've got three options, two of which require an internet connection, one
part time, the other full time. The third option has the constraint on the
size of the data in question.
- Have your preference of a resultant hash check in a plain text file
sitting somewhere on your web server. The
"Venkatarangan MJ" wrote...
How do I unsubscribe from the group as I have stopped using SQLITE from
quite some time now?
Look at the bottom of this email and click on the last link. I think you
can figure it out the rest.
On 15 Oct 2014, at 12:54pm, Prakash Premkumar wrote:
> I'm trying to understand the sqlite select query optimizer. It works by
> assigning costs to each relation in FROM clause.
That is only a little bit of how it works. Have you read these ?
I'm trying to understand the sqlite select query optimizer. It works by
assigning costs to each relation in FROM clause. As far as I understand, it
primarily uses the logarithmic estimate of the number of rows in the
Query optimization algorithms like IBM System R algorithm assigns
On 10/15/2014 07:19 AM, Sam Carleton wrote:
When I use the SQLite Manager, I am able to run this query just fine:
SET IsActive = 1
WHERE EventNodeId IN (SELECT w.EventNodeId
FROM EventNode as w, EventNode as m on
How do I unsubscribe from the group as I have stopped using SQLITE from quite
some time now?
sqlite-users mailing list
Mail list logo