Future Filing Online Knowledgebase
Search:     Advanced search

Why is my database size so large?

Article ID: 25
Last updated: 13 Jul, 2009
Add comment
Views: 200
Comments: 0

Kixzo utilizes a database called Firebird which is a file based database.  When data is added into the file based database, the size of the database grows as expected.  However whenever something is deleted, that information is removed from the database, but the space created when the data existed remains.  When new information is added to the database, it is placed into that space left empty by the previous deleted data.  Once all the spacing is filled up, new space is then created.

Here is an analogy.

You created a brand new shelving case with 20 shelves in it.  Each shelf is filled up figurines or small statues.  At some point in time you decide that you no longer like the figurines/small statues and decide to get rid of half of them.  Although the figurines/small statues have been removed, the 20 shelves you created remain.  Now at some later point in time you decide to go with dishes to replace those figurines. Those dishes are now placed in the locations that the figurines/small statues once occupied.  Until all the shelving is used up, no more space is needed.  However, once the shelving is filled, then new space is created. 

This article was:   Helpful Not Helpful Add comment
Prev   Next
Error Messages      Failed to Register Kixzo message

RSS