A question was if a sort is also programmatically interruptable. With the knowledge that the command tool calls sqlite3_interrupt upon the first CONTROL-C, this is easily tested. From the timings below it appears to be so.
$ sqlite3 SQLite version 3.25.2 2018-09-25 19:08:10 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table t (a); insert into t with r as (select 1 as i union all select i+1 from r where i<10000000) select 'row ' || i from r; .timer on select * from t order by a limit 1 offset 100; row 1000085 Run Time: real 0.949 user 0.944579 sys 0.001983 select * from t order by a limit 1 offset 100; ^C Run Time: real 0.160 user 0.159095 sys 0.000481 Error: near line 2: interrupted sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
