Re: SQLite appears to be compiled without large file support

On 2013-12-05 1:16 AM, David Kelly wrote:
> Repeat adding -s to ls. I think that will list the position of EOF. I
> think you have a sparse file which physically occupies 119k but has
> massive holes which have yet to be assigned disk blocks.

It's the other way around-- ls -l shows the logical length of the file,
and ls -s shows the actual number of blocks used.

E.g.

$ dd if=/dev/zero of=sparse count=1 seek=100000000
1+0 records in
1+0 records out
512 bytes transferred in 0.001 secs (512000 bytes/sec)
$ ls -ls sparse
64 -rw-r----- 1 khym wheel 51200000512 Dec 5 09:09 sparse
Received on 2013-12-05 16:13:18 CET