<![CDATA[FrontAccounting forum — Increase number of characters for 0_gl_trans.account]]> https://frontaccounting.com/punbb/viewtopic.php?id=126 Thu, 24 Jan 2008 22:29:30 +0000 PunBB <![CDATA[Re: Increase number of characters for 0_gl_trans.account]]> https://frontaccounting.com/punbb/viewtopic.php?pid=337#p337 Why do you need so many characters for account ID's. It is just vaste of space. The most I have seen around is 10 characters, and I believe even this is too much.
Not all tables need transactions so it is just overhead to use InnoDB for them.

/Joe

]]> Thu, 24 Jan 2008 22:29:30 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=337#p337 <![CDATA[Increase number of characters for 0_gl_trans.account]]> https://frontaccounting.com/punbb/viewtopic.php?pid=336#p336 Hello:

I am evaluating this platform. In order to migrate from an existing GL system I increased the 'account' field from '0_gl_trans' from 11 to 20 characters.

I suggest to make it so in the default configuration.

I also noticed that some tables are MyISAM, others are InnoDB. I suggest forcing all of them to be InnoDB.

Regards,

Alex

]]> Thu, 24 Jan 2008 20:37:21 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=336#p336