Re: [sqlite] Slow Query on large database Help

On Wed, 7 Aug 2013 23:13:41 +0200 Petite Abeille wrote: > On Aug 7, 2013, at 9:25 PM, Christopher W. Steenwyk > wrote: > > > Ah, sorry about the attachments, you can find the files here: > > https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb > >

[sqlite] System.Data.SQLite version 1.0.88.0 released

System.Data.SQLite version 1.0.88.0 (with SQLite 3.7.17) is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] Slow Query on large database Help

On Wed, Aug 7, 2013 at 2:54 PM, Christopher W. Steenwyk wrote: > Hi, > > I have been working on a large database and its queries now for several > weeks and just can't figure out why my query is so slow. I've attached the > schema, my query, and the results of EXPLAIN QUERY

Re: [sqlite] Slow Query on large database Help

On Aug 7, 2013, at 9:25 PM, Christopher W. Steenwyk wrote: > Ah, sorry about the attachments, you can find the files here: > https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb Ah, also, your schema has a very, hmmm, Entity–attribute–value (EAV) smell to it (object,

Re: [sqlite] Slow Query on large database Help

On Aug 7, 2013, at 9:25 PM, Christopher W. Steenwyk wrote: > Ah, sorry about the attachments, you can find the files here: > https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb > > And yes, as the final part of the DB creation I do run ANALYZE. And I do > think the indexes

Re: [sqlite] Slow Query on large database Help

Ah, sorry about the attachments, you can find the files here: https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb And yes, as the final part of the DB creation I do run ANALYZE. And I do think the indexes are correct for the query. On Wed, Aug 7, 2013 at 3:07 PM, Petite Abeille

Re: [sqlite] Slow Query on large database Help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/08/13 11:54, Christopher W. Steenwyk wrote: > I have been working on a large database and its queries now for > several weeks and just can't figure out why my query is so slow. I've > attached the schema, my query, and the results of EXPLAIN

Re: [sqlite] Slow Query on large database Help

On 7 Aug 2013, at 7:54pm, Christopher W. Steenwyk wrote: > I've attached the > schema, my query, and the results of EXPLAIN QUERY from sqliteman. Sorry, attachments don't work on this list (we don't want everyone sending us their homework). Could you instead just post

Re: [sqlite] Slow Query on large database Help

On Aug 7, 2013, at 8:54 PM, "Christopher W. Steenwyk" wrote: > The attached query takes over 6 days to run. “Patience – A minor form of despair, disguised as a virtue.” Also… attachments are stripped out by the mailing list. You may want to try to inline them instead.

[sqlite] Slow Query on large database Help

Hi, I have been working on a large database and its queries now for several weeks and just can't figure out why my query is so slow. I've attached the schema, my query, and the results of EXPLAIN QUERY from sqliteman. A few notes about this database: Its approximately 10GB in size, but I have it

Re: [sqlite] How to "upgrade" a DB without write access to its file, or to the direction it's in?

On Wed, Aug 7, 2013 at 12:15 PM, Dominique Devienne wrote: > On Wed, Aug 7, 2013 at 2:45 PM, Clemens Ladisch > wrote: > > > Dominique Devienne wrote: > > > We can of course copy the db file somewhere else with r/w access, or > copy > > > the DB into an

Re: [sqlite] How to "upgrade" a DB without write access to its file, or to the direction it's in?

On Wed, Aug 7, 2013 at 2:45 PM, Clemens Ladisch wrote: > Dominique Devienne wrote: > > We can of course copy the db file somewhere else with r/w access, or copy > > the DB into an in-memory DB (for each table, create table memdb.foo as > > select * from dskdb.foo) and upgrade

Re: [sqlite] how to use sqlite in excel vba?

> The vbRichClient appears to be *very sparsely* documented In practice this is not really a problem. I have been using this library for a few years (in a commercial application) and never found it difficult to get the answers. This is because the SQLite objects and methods closely resemble ADO

Re: [sqlite] Query on Update or Selective Insert

On 7 August 2013 15:25, Simon Slavin wrote: > > On 7 Aug 2013, at 9:50am, techi eth wrote: > >> I am trying to update 100 variables at a time & due to some of the reason 99 >> th or any mid index variable cause update to fail. >> >> In that case this

Re: [sqlite] Query on Update or Selective Insert

On 7 Aug 2013, at 9:50am, techi eth wrote: > I am trying to update 100 variables at a time & due to some of the reason 99 > th or any mid index variable cause update to fail. > > In that case this query has to execute it again for the entire variable or > only for failed

Re: [sqlite] SQLITE For Windows phone

See http://developer.nokia.com/Community/Wiki/How_to_use_SQLite_in_Windows_Phone On Wed, Aug 7, 2013 at 2:23 AM, Cadu . wrote: > Hello I wonder if you could send me a tutorial on how to add the SQLITE > project in Visual Studio 2012, since not found any material

[sqlite] SQLITE For Windows phone

Hello I wonder if you could send me a tutorial on how to add the SQLITE project in Visual Studio 2012, since not found any material regarding this project, I thank the collaboration ___ sqlite-users mailing list

Re: [sqlite] How to "upgrade" a DB without write access to its file, or to the direction it's in?

Dominique Devienne wrote: > We can of course copy the db file somewhere else with r/w access, or copy > the DB into an in-memory DB (for each table, create table memdb.foo as > select * from dskdb.foo) and upgrade and read that one instead, but I was > wondering whether there's another better

[sqlite] How to "upgrade" a DB without write access to its file, or to the direction it's in?

We use SQLite for persistence of our project meta-data (the data itself is still in a proprietary binary format). For now, on project load, the meta-data DB file is read in full into memory (C++ objects) then closed, and re-written from scratch on save or save-as, instead of trying to update it in

Re: [sqlite] Query on Update or Selective Insert

The standard behavior is to back out any changes made by the current statement, which means that none of the changes to any of the rows are preserved in case of a constraint violation. SQLite offers an ON CONFLICT clause which allows the programmer to choose from a set of defined behaviours.

Re: [sqlite] Query on Update or Selective Insert

Apologies to use programming convention!!! Here I mean to have Colum UPDATE table_name SET column1 = value1, column2 = value2, columnN = valueN Here N is 100. Cheers - Techi On Wed, Aug 7, 2013 at 3:26 PM, Hick Gunter wrote: > What do you mean by "variable"? > >

Re: [sqlite] Query on Update or Selective Insert

What do you mean by "variable"? -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Mittwoch, 07. August 2013 10:50 An: General Discussion of SQLite Database Betreff: [sqlite] Query on Update or Selective Insert Query on Update or Selective Insert: I am trying

[sqlite] Query on Update or Selective Insert

Query on Update or Selective Insert: I am trying to update 100 variables at a time & due to some of the reason 99 th or any mid index variable cause update to fail. In that case this query has to execute it again for the entire variable or only for failed variable. Cheers - Techi