<![CDATA[FrontAccounting forum — Maintaining FA Tables]]> 2016-07-30T16:54:18Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=6388 <![CDATA[Maintaining FA Tables]]> The Wiki has been updated with MySQL table Defragmentation methods.

Over a period of time, FrontAccounting's MySQL tables accumulate a lot of deleted records. Purging the "marked for deletion" records will shrink the table space, re-index / defragment it and make it faster in operation.

This is important for those running FA having a lot of data and for those running several companies in one FA server. - especially so when a fiscal year is closed and then deleted.

]]> https://frontaccounting.com/punbb/profile.php?id=364 2016-07-30T16:54:18Z https://frontaccounting.com/punbb/viewtopic.php?pid=25893#p25893