Re: [sqlite] Slow Query on large database Help

[James K. Lowden]

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?attribute?value (EAV)
> smell to it (object, attribute, types, values, characteristics,
> metadata, etc, etc). Most likely not helping. 

Most assuredly not helping, because cannot help.  What it does is
make your queries vague and complex, and prevent the DBMS from doing
its job (because you haven't expressed the rules of the data).  

ANALYZE is the last step on the road to good performance.  The first
step is analysis!  

--jkl
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.88.0 released

[Joe Mistachkin]

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 mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Richard Hipp]

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 few notes about this database:
> Its approximately 10GB in size, but I have it on a SSD on a linux machine
> with 12 GB of RAM on a 24 core PC.
>
> As for data in the tables...
> 'Objects' has 35 rows
> 'frames' has 51896158 rows
> 'attribute_types' has 50 rows
> 'attribute_values' has 200 rows
> 'metrics' has 68682102 rows
>
> For every object there are approximately 5 rows that relate to it in
> 'object_characteristics' and another 20 rows in 'metadata'.
>
> The attached query takes over 6 days to run.
>
> Any help or suggestions would be greatly appreciated.
>

Can you please send the output of ".dump sqlite_stat1".

Also, if you can run sqlite3_analyzer on the database file and send us
that, so much the better.

Thanks.


>
> I noticed that the part of the query for 'frames' is not using a covering
> index, cut I can't figure out why. I Was wondering if that is why it was
> slow. In the query I am only referencing items that are within an index but
> it keeps using the PRIMARY KEY. So that was one thought I had.
>
> Thanks in advance!
> Chris
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Petite Abeille]

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, characteristics, metadata, etc, etc). 
Most likely not helping. Anyway, to each their own... 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Petite Abeille]

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 query.

Wild, random stab in the dark…

I suppose this is an equivalent query:

selectmetadata.attribute_value_id as metadata_value_id, 
  object_characteristics.attribute_value_id as object_type_value_id, 
  sum( case when metrics.color = 1 and metrics.quality > 0 then 1 end ) 
as pass, 
  count( metrics.id ) as total
from  metadata

join  frames
onframes.id between metadata.start_frame_id and metadata.stop_frame_id

join  metrics
onmetrics.frame_id = frames.id

join  object_characteristics
onobject_characteristics.object_id = metrics.object_id

where frames.session_frame_id > 12 
and   frames.ticks > 10
and   exists
  (
select  1
fromattribute_types

where   attribute_types.id = metadata.attribute_type_id
and attribute_types.type = 'Metadata Type'
  )
and   exists
  (
select  1
fromattribute_types

where   attribute_types.id = 
object_characteristics.attribute_type_id
and attribute_types.type = 'Object Type'
  )

group by  metadata.attribute_value_id,
  object_characteristics.attribute_value_id


explain query plan:

0|0|0|SCAN TABLE metadata USING COVERING INDEX metadata_type_value_idx (~50 
rows)
0|0|0|EXECUTE CORRELATED SCALAR SUBQUERY 1
1|0|0|SEARCH TABLE attribute_types USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)
0|1|2|SEARCH TABLE metrics USING INDEX metrics_idx (frame_id>? AND frame_idhttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Christopher W. Steenwyk]

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, 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-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Roger Binns]

-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 QUERY from
> sqliteman.

Attachments get stripped from the mailing list.  You can put them
somewhere like Dropbox.

Did you run analyze?

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU/Linux)

iEYEARECAAYFAlICmtMACgkQmOOfHg372QSRLwCgkb0vJAQ/cnH+nr85W2PUJJrY
U0kAoOPseXJlXtSqJw95tNgq1RUMHp37
=AvMF
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Simon Slavin]

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 the 
EXPLAIN QUERY for it ?

First, have you done an ANALYZE ?

Second, do you have, or think you have, indexes appropriate to your query ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Query on large database Help

[Petite Abeille]

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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Slow Query on large database Help

[Christopher W. Steenwyk]

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 a SSD on a linux machine
with 12 GB of RAM on a 24 core PC.

As for data in the tables...
'Objects' has 35 rows
'frames' has 51896158 rows
'attribute_types' has 50 rows
'attribute_values' has 200 rows
'metrics' has 68682102 rows

For every object there are approximately 5 rows that relate to it in
'object_characteristics' and another 20 rows in 'metadata'.

The attached query takes over 6 days to run.

Any help or suggestions would be greatly appreciated.

I noticed that the part of the query for 'frames' is not using a covering
index, cut I can't figure out why. I Was wondering if that is why it was
slow. In the query I am only referencing items that are within an index but
it keeps using the PRIMARY KEY. So that was one thought I had.

Thanks in advance!
Chris
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Richard Hipp]

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 memdb.foo as
> > > select * from dskdb.foo) and upgrade and read that one instead, but I
> was
> > > wondering whether there's another better solution we could use?
> >
> > You can use the backup API to copy an entire database at once:
> > 
> >
>
> Thanks. That's more efficient and less code for sure, and what we're using
> now.
>
> I just thought there might be a different trick possible to avoid
> duplicating the whole DB, like forcing the journal to be in-memory, or
> using WAL instead, or something.
>
> If that's the best we can do, then so be it.
>

That's probably about the best that is built-in.  However...

You could write a "shim" VFS to fake a filesystem that appears to provide
read/write semantics but which really only reads.  All writes would be
stored in memory and would be forgotten the moment you close the database
connection.

The "VFS" is an object that sets in between the SQLite core and the
operating system and provides a uniform interface to operating-system
services.  SQLite comes with built-in VFSes for unix and windows.  But you
can add additional VFSes at run-time.  A "shim" VFS is one that passes most
of the work through to one of the original VFSes but modifies some of the
requests.

So, your shim VFS would keep an in-memory record of all modified database
pages.  Read requests first check this modification cache and reply from it
if present, otherwise it passes the read request down to the original
(real) VFS.  Write requests simply update the modification cache.



>
> The reason I'd rather avoid the full copy is that the tables upgraded
> typically will update a tiny subset of the DB, which I've seen as large as
> 100 MB. So rather than duping a 100 MB disk DB into a 100 MB memory DB so I
> can select from it (at the proper schema version) so I can populate my C++
> data structures (likely smaller than 100 MB, but still in the 20-50 MB
> range), that adds quite a bit of memory consumption, while the journal
> itself would grow to only a few MBs.
>
> Thanks again for the suggestion though. --DD
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Dominique Devienne]

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 instead, but I was
> > wondering whether there's another better solution we could use?
>
> You can use the backup API to copy an entire database at once:
> 
>

Thanks. That's more efficient and less code for sure, and what we're using
now.

I just thought there might be a different trick possible to avoid
duplicating the whole DB, like forcing the journal to be in-memory, or
using WAL instead, or something.

If that's the best we can do, then so be it.

The reason I'd rather avoid the full copy is that the tables upgraded
typically will update a tiny subset of the DB, which I've seen as large as
100 MB. So rather than duping a 100 MB disk DB into a 100 MB memory DB so I
can select from it (at the proper schema version) so I can populate my C++
data structures (likely smaller than 100 MB, but still in the 20-50 MB
range), that adds quite a bit of memory consumption, while the journal
itself would grow to only a few MBs.

Thanks again for the suggestion though. --DD
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Bart Smissaert]

> 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 objects and methods (and most likely VBA people
will be familiar with that) and also because answers are easy to get,
either from Olaf
or via the microsoft.public.vb.general.discussion newsgroup.
I am also happy to provide demo code.
Very much recommended.

RBS


On Tue, Aug 6, 2013 at 4:27 PM, Larry Brasfield
wrote:

> Wolfgang Enzinger wrote:
>
>>
>> > Assuming you actually do need to compile something, (identity of which
>> > you provide few good clues), you might consider a package I had good
>> > luck with, a SQLite wrapper called 'Litex', available at
>> >
>> > https://www.assembla.com/wiki/**show/litex
>>
>> The download links on this page don't seem to work properly ...?
>>
>> My recommendation for a SQLite COM wrapper would be this:
>> http://www.vbrichclient.com
>>
>
> I'm not getting into a debate about what is best for the OP, having too
> few clues to do so.
>
> The vbRichClient appears to be *very sparsely* documented, with nothing on
> the SQLite interfaces.  And it is closed source.  There does not seem to be
> any demo code for the SQLite functionality.  So a user would be left
> guessing how to use it from what the type library suggests.
>
> The Litex wrapper source is available in zipped form via the Subversion
> repository browser visible at the page I linked.  It can be built in
> Unicode and non-Unicode forms.  There is extensive documentation for it.
>  It is partitioned into a useful C++ wrapper and an ActiveX packaging over
> that wrapper.
>
> The Litex source is a little old, and had to be modified slightly to build
> with more modern tools than VisualC++ 6.0.  That would not be an issue for
> the OP.
>
> Cheers,
> --
> Larry Brasfield
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query on Update or Selective Insert

[Simon Davies]

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 variable or
>> only for failed variable.
>
> If the whole of the UPDATE cannot be completed, none of the UPDATE is done.
>
> Simon.

If a conflict arises, none of the row is updated.
But see http://www.sqlite.org/lang_conflict.html. An update with
ignore conflict resolution can update rows even if some rows cause
conflict; those rows that cause conflict will be skipped.

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query on Update or Selective Insert

[Simon Slavin]

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 of the UPDATE cannot be completed, none of the UPDATE is done.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE For Windows phone

[Matthijs ter Woord]

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 thank the collaboration
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE For Windows phone

[Cadu .]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Clemens Ladisch]

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 solution we could use?

You can use the backup API to copy an entire database at once:



Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Dominique Devienne]

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 place.

When loading an older project, we need to upgrade (within a transaction)
the meta-data DB to the schema version understood by the current
application, load the upgraded DB, then rollback the DB file, to leave the
original project untouched.

That's working fine, except when the user opening the project has read-only
access to the DB-file (case#1) or even to the directory the DB file is in
(case#2).

We run in normal-mode, not wal-mode, i.e. SQLite creates a journal file on
the upgrade, and possibly also changes the .db itself (to record the
ongoing transaction? I don't know). But in the read-only cases described
above, the upgrade fails, and the user thus cannot open the project.

My question is then whether there's a way to perform the to-be-rolled-back
upgrade in such a way to not run afoul of the read-only file/dir
permissions?

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 solution we could use?

Thanks, --DD
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query on Update or Selective Insert

[Hick Gunter]

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. See http://www.sqlite.org/lang_conflict.html

But regardless of the choice, each row of a table is either modified in all 
specified columns or in none at all.

Note that without a WHERE clause the UPDATE statement will modify all rows of 
the table.

-Ursprüngliche Nachricht-
Von: techi eth [mailto:techi...@gmail.com]
Gesendet: Mittwoch, 07. August 2013 12:06
An: General Discussion of SQLite Database
Betreff: 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"?
>
> -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 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
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> --
> 
>  Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> Klitschgasse 2 - 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This e-mail is confidential and may well also be legally privileged.
> If you have received it in error, you are on notice as to its status
> and accordingly please notify us immediately by reply e-mail and then
> delete this message from your system. Please do not copy it or use it
> for any purposes, or disclose its contents to any person as to do so
> could be a breach of confidence. Thank you for your cooperation.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query on Update or Selective Insert

[techi eth]

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 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 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
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> --
>  Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> Klitschgasse 2 – 4, A - 1130 Vienna, Austria
> FN 157284 a, HG Wien
> Tel: +43 1 80100 0
> E-Mail: h...@scigames.at
>
> This e-mail is confidential and may well also be legally privileged. If
> you have received it in error, you are on notice as to its status and
> accordingly please notify us immediately by reply e-mail and then delete
> this message from your system. Please do not copy it or use it for any
> purposes, or disclose its contents to any person as to do so could be a
> breach of confidence. Thank you for your cooperation.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query on Update or Selective Insert

[Hick Gunter]

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 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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Query on Update or Selective Insert

[techi eth]

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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users