We're developing a new database using Firebird. The database size has been
sitting at 8 mb for over a month. One day last week it increased to 44 mb.
We have been doing a lot of changes, both to the structure and to the data,
over the whole period, so I don't know why it suddenly increased so
dramatically. We have now deleted all the data and want to decrease the
database size again. How can we do that?

Regards Coral

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Adam
Sent: Friday, 3 February 2006 8:43 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Ignoring a FK index

> I gave you no help at all. :-)
>

Giving help <> Providing complete solution.

We didn't quite get to the bottom of it, but that is more because of
me not getting to the bottom of why such an index would be more
useful. Your statements got my brain thinking again, especially
suggesting that the difference in performance may be other factors. In
any case, it works fast enough now so on to optimising something else.

Adam







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

Visit http://firebird.sourceforge.net 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