Subject RE: [firebird-support] Compacting the database from a App
Author Andrew Gable
So in other words I should not worry about having a compact function within
the software

As you can tell I am still trying to get over Jet (as I had to compact that
weekly)

Firebird is FANTASTASIC :) I love the way it allows me to use it for
embedded systems (like my new Caf├ęPoS Software)

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 15 October 2010 6:34 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Compacting the database from a App

On 10/15/2010 1:00 PM, Andrew Gable wrote:
>
> I am using Vb6 and I would like to know how I compact the Firebird
database
> from within my Application
>

If by "compact" you mean that you'd like to make space in the
database available for re-use by the database, Firebird does that
automatically and continuously.

If you mean that you'd like to reduce the size of the database
file, that's another problem. The only way to reduce the file
size is to stop the database, back it up, restore it to another
file, rename the old database file, rename the new database to
the old name, and restart it.

The backup and restore can be done through the services
interface. The file renaming and etc. require operating
system services.

And to what end? In very few cases a database enjoys a one-time
expansion then contracts never to expand again. More generally,
it expands for a while as the pattern of updates and deletes
becomes established, then grows as the amount of data stored
grows - whether slowly or rapidly.

Good luck,

Ann


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links



----------


No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.862 / Virus Database: 271.1.1/3198 - Release Date: 10/15/10 07:34:00


[Non-text portions of this message have been removed]