On 30 Dec 2016, at 11:15am, MONSTRUO Hugo González <americasoftw...@gmail.com> 
wrote:

> [URL for a copy of his database]
> 
> SELECT COUNT (*) FROM bm_ppal
> 59.046 seconds of delay
> 
> SELECT COUNT (*) FROM bm_ppal ORDER BY nbmId
> 1.128 minutes of delay
> 
> SELECT COUNT (nbmId) FROM bm_ppal ORDER BY nbmId
> 1.089 minutes of delay
> 
> in mi program y use sqlite version: 3.8.6

Here are results from the SQLite shell tool on my system:

SQLite version 3.14.0 2016-07-26 15:17:14
Enter ".help" for usage hints.
sqlite> .timer ON
sqlite> PRAGMA integrity_check;
ok
Run Time: real 11.962 user 9.205414 sys 2.752183
sqlite> SELECT COUNT (*) FROM bm_ppal;
724816
Run Time: real 0.016 user 0.005380 sys 0.009552
sqlite> SELECT COUNT (*) FROM bm_ppal ORDER BY nbmId;
724816
Run Time: real 0.016 user 0.005368 sys 0.009806
sqlite> SELECT COUNT (nbmId) FROM bm_ppal ORDER BY nbmId;
724816
Run Time: real 0.058 user 0.046052 sys 0.010368
sqlite> 

Note that the 'real' timings on my system are all less than a second.  This is 
far more like what I would expect from SQLite.  Timings of even 1 minute for 
less than a million rows would be unusual.

It would appears that either

(a) The problem has been fixed sometime between 3.8.6 and 3.14.0 … OR
(b) There’s a problem with valentina studio 6

Of the two, (a) is the most likely.  A good next step for you to investigate 
would be to download and the SQLite shell tool for your platform.  You can find 
it as one of the "Precompiled Binaries" on this page

<https://sqlite.org/download.html>

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

Reply via email to