Freelist count after Vacuum

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Freelist count after Vacuum

Dave Wellman
Hi,

Is it a reasonable assumption that immediately following a VACUUM command
the freelist_count will always be 0, or maybe 1?

Cheers,

Dave

 

 

Ward Analytics Ltd - information in motion

Tel: +44 (0) 118 9740191

Fax: +44 (0) 118 9740192

www:  <http://www.ward-analytics.com> http://www.ward-analytics.com

 

Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR

Registered company number: 3917021 Registered in England and Wales.

 

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Freelist count after Vacuum

Richard Hipp-3
On Thu, Oct 9, 2014 at 12:25 PM, Dave Wellman <[hidden email]>
wrote:

> Hi,
>
> Is it a reasonable assumption that immediately following a VACUUM command
> the freelist_count will always be 0, or maybe 1?
>


I think it should always be 0.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Freelist count after Vacuum

Dave Wellman
Ok, thanks.

Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com

Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR
Registered company number: 3917021 Registered in England and Wales.

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Richard Hipp
Sent: 09 October 2014 17:29
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Freelist count after Vacuum

On Thu, Oct 9, 2014 at 12:25 PM, Dave Wellman <[hidden email]>
wrote:

> Hi,
>
> Is it a reasonable assumption that immediately following a VACUUM
> command the freelist_count will always be 0, or maybe 1?
>


I think it should always be 0.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users