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
.
* 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
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
; 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:
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
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,
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
7 matches
Mail list logo