<![CDATA[FrontAccounting forum — Increase number of characters for 0_gl_trans.account]]> 2008-01-24T22:29:30Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=126 <![CDATA[Re: Increase number of characters for 0_gl_trans.account]]> 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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2008-01-24T22:29:30Z https://frontaccounting.com/punbb/viewtopic.php?pid=337#p337 <![CDATA[Increase number of characters for 0_gl_trans.account]]> 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

]]> https://frontaccounting.com/punbb/profile.php?id=130 2008-01-24T20:37:21Z https://frontaccounting.com/punbb/viewtopic.php?pid=336#p336