On 29/03/16 11:44, Małgorzata Barchańska gosia@fastdata.com.pl
[firebird-support] wrote:
> I'm very curious - so what makes our database file so big? Sum of clear metadata
> and raw data is about 2,4GB, and what with other 12GB? Is anything we
> can do to shrink our big database file (drop useless indexes or
> something like that)?
You could try running your database through gstat.exe (in your
bin-directory of Filebird, if you installed the development tools with
it). You can learn a lot about the way the database-pages are filled per
table.
You can find a manual for it here:
http://www.firebirdsql.org/pdfmanual/Firebird-gstat.pdf
Grtz,
Rik
__._,_.___
Posted by: Rik van Kekem <rik@graficalc.nl>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment