1 Topic by apmuthu (edited by apmuthu 07/30/2016 05:05:15 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Topic: 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.

Post's attachments

Defragment tables in MySQL.pdf 98.7 kb, 4 downloads since 2016-07-30 

You don't have the permssions to download the attachments of this post.

apmuthu's Website