1 Topic by alex (edited by alex 01/24/2008 08:39:35 pm)

  • alex
  • New member
  • Offline
  • Registered: 01/24/2008
  • Posts: 4

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

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