[sqlite] order by not working in combination with random()

2015-08-29 Thread Yahoo! Mail
On 08/28/2015 09:36 PM, Scott Robison wrote: > On Fri, Aug 28, 2015 at 3:47 AM, Yahoo! Mail yahoo.com >> wrote: >> >> On 08/26/2015 09:03 PM, Richard Hipp wrote: >> >> Time stands still for multiple rows, as long as they are within the >>> same sql

[sqlite] order by not working in combination with random()

2015-08-28 Thread Yahoo! Mail
. * re-run the same command but with 10 rows only; it *should* have finished within milliseconds, but it repeated the same task as above, even the database size remained the same (28GB that is). On 08/28/2015 05:45 PM, R.Smith wrote: > > > On 2015-08-28 03:09 PM, Yahoo! Mail

[sqlite] order by not working in combination with random()

2015-08-28 Thread Yahoo! Mail
8/2015 03:43 PM, R.Smith wrote: > > On 2015-08-28 01:17 PM, Yahoo! Mail wrote: >> Obviously you did not get my issue; something is wrong and your timer >> suggestion indicates this. During the execution of each command, I >> would monitor it with *watch "du test.d

[sqlite] order by not working in combination with random()

2015-08-28 Thread Yahoo! Mail
; drop table if exists t1; create table t1(a datetime); vacuum t1; begin; with recursive c(x) as (values(1) union all select x + 1 from c where x < 100) insert into t1(a) select datetime('now') from c; commit; Run Time: real 209.612 user 4.724000 sys 21.588000* On 08/28/2015 01:

[sqlite] order by not working in combination with random()

2015-08-28 Thread Yahoo! Mail
On 08/26/2015 09:03 PM, Richard Hipp wrote: > Time stands still for multiple rows, as long as they are within the > same sqlite3_step() call. For example, if you run: > > CREATE TABLE t1(a DATETIME); > WITH RECURSIVE > c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100

[sqlite] What software is deployed more than SQLite?

2015-05-06 Thread Yahoo! Mail
I run a simple search on a Windows XP (virtual) machine of mine and found the following programs using SQLite: * Adobe Reader * Adobe Acrobat Professional * Avira Antivir (almost 400 million use it based on their official website) * Apple Application Support On 05/03/2015 11:32 PM,

[sqlite] What software is deployed more than SQLite?

2015-05-03 Thread Yahoo! Mail
How about curl? This is taken directly from the official website: " curl is used in command lines or scripts to transfer data. It is also used in cars, television sets, routers, printers, audio equipment, mobile phones, tablets, settop boxes, media players and is the internet transfer backbone