[sqlite] Ответ: Re: [sqlite] count up how much an free space on DB

Thanks Richard. I will try. --- [EMAIL PROTECTED] пишет: > Artem Yankovskiy <[EMAIL PROTECTED]> wrote: > > Question, whether probably to count up how much an > > free space there is in this a DB? > > > > If the first byte of the database file is called > byte 0, > then bytes 16 and 17 form a

Re: [sqlite] count up how much an free space on DB

Artem Yankovskiy <[EMAIL PROTECTED]> wrote: > Question, whether probably to count up how much an > free space there is in this a DB? > If the first byte of the database file is called byte 0, then bytes 16 and 17 form a 16-bit big-endian integer which is the number of bytes per page. Bytes

[sqlite] count up how much an free space on DB

Hello. There is a DB. auto_vacuum is not used. One of tables of a database contains 500 records. We for example delete from it 300 records. The place in a database was released, but the size of a file has not decreased how is not set auto_vacuum. Question, whether probably to count up how much an