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

2006-12-14 Thread Artem Yankovskiy 
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 16-bit big-endian
> integer
> which is the number of bytes per page.  Bytes 36-39
> form
> a 32-bit big-endian integer which is the number of
> unused
> pages in the database.  If you multiple those two
> numbers
> together, you will get the amount of reusable free
> space
> in the database file.
> 
> --
> D. Richard Hipp  <[EMAIL PROTECTED]>
> 
> 
>
-
> To unsubscribe, send email to
> [EMAIL PROTECTED]
>
-
> 
> 








Вы уже с Yahoo!? 
Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-12-14 Thread drh 
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 36-39 form
a 32-bit big-endian integer which is the number of unused
pages in the database.  If you multiple those two numbers
together, you will get the amount of reusable free space
in the database file.

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-12-14 Thread Artem Yankovskiy 
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
free space there is in this a DB?








Вы уже с Yahoo!? 
Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-