[sqlite] Unsubscription

How do I unsubscribe from the group as I have stopped using SQLITE from quite some time now? Thanks. Regards Rangan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unable to prepare a statement

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: UPDATE EventNode SET IsActive = 1 WHERE EventNodeId IN (SELECT w.EventNodeId FROM EventNode as w, EventNode as m on m.objectId =

[sqlite] sqlite Query Optimizer

Hi, 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 relation. Query optimization algorithms like IBM System R algorithm assigns

Re: [sqlite] sqlite Query Optimizer

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 ?

Re: [sqlite] Unsubscription

"Venkatarangan MJ" wrote... How do I unsubscribe from the group as I have stopped using SQLITE from quite some time now? Thanks. Regards Rangan. Look at the bottom of this email and click on the last link. I think you can figure it out the rest. jic

Re: [sqlite] Make a database read-only?

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

Re: [sqlite] Make a database read-only?

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... > haha You can advertise your database with the tagline, "Please compute

Re: [sqlite] Performance issue when copying data from one sqlite database to another

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

[sqlite] SSL Rating on SQLite.org

Hello All/Richard, Unrelated to databases, sql, and sqlite but I noticed the poor rating on sqlite.org of an F: https://www.ssllabs.com/ssltest/analyze.html?d=sqlite.org It would be nice to have a better rating! On the positive side, oracle.com doesn't even have an SSL for the homepage. --

Re: [sqlite] Unsubscription

Venkatarangan MJ wrote: >How do I unsubscribe from the group as I have stopped using SQLITE from quite >some time now? >Thanks. >Regards >Rangan. 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

[sqlite] Search query alternatives.

Hi all, 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

Re: [sqlite] Search query alternatives.

On 10/15/2014 6:05 PM, Michael Falconer wrote: addresses connections events family person repositories sources texts 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

Re: [sqlite] Search query alternatives.

On 2014/10/16 00:05, Michael Falconer wrote: Hi all, 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

Re: [sqlite] Search query alternatives.

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

Re: [sqlite] Search query alternatives.

Igor, 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

Re: [sqlite] Search query alternatives.

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,

Re: [sqlite] Search query alternatives.

Thanks Stephen, 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