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
>
> Ah, also, your schema has a very, hmmm, Entity?att
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 SQLite
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 from sqliteman.
>
> A
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, attribute, types, values, char
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 are correct for the quer
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 wrote:
>
> On Aug 7
-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 QUER
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 your SELECT command and
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.
___
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
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 in-memory DB (for each table, create table m
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 and read that one in
> 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 ob
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 query has to execute it again for the entire v
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 variable.
If the whole
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 regarding this
> project, I than
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
sqli
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 solut
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
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. Se
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"?
>
> -Ursprüngliche Nac
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
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
__
23 matches
Mail list logo