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
