FrontAccounting forum — Mixture of InnoDB and MyISAM type for FA MySQL tables

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (elax) — Mon, 09 Jan 2012 17:26:44 +0000

uma wrote:

Joe,
We have several times heard of FA 2.4 release. But everything is kept in the intrigue. Please give us (community) a couple of words about new features, changes, release time e.t.c. -)

Why not starting a new topic for this ?

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (uma) — Mon, 09 Jan 2012 14:59:48 +0000

Joe,

We have several times heard of FA 2.4 release. But everything is kept in the intrigue. Please give us (community) a couple of words about new features, changes, release time e.t.c. -)

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (joe) — Wed, 23 Nov 2011 00:56:29 +0000

We would not recommend this. FrontAccounting is using transactions to handle the multi-user environment. If using myisam for the tables that should be innodb, we loose the ability to have multi-user operation.
I would recommend you to move to another hosting service.

/Joe

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (prages) — Tue, 22 Nov 2011 19:31:33 +0000

Joe

my webhosting is now disabling innodb engine. they say that is heavy on cpu and ram resources. can i convert innodb tables to myisam?

will there be any problem? since my usage of frontaccounting is not high. very few transaction per day.

thanks in advance. looking for early reply.

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (Apple) — Wed, 12 Oct 2011 06:51:26 +0000

Joe, thanks for your info.

Re: Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (joe) — Wed, 12 Oct 2011 06:22:04 +0000

We are changing to InnoDB for all tables in release 2.4 (next major)

/Joe

Mixture of InnoDB and MyISAM type for FA MySQL tables

null@example.com (Apple) — Wed, 12 Oct 2011 05:20:11 +0000

Can anyone please explain why FA using different types of table ie. either InnoDB or MyISAM in MySQL. Is there a need to change one type to another in term of performance?

Please advice which type shall I change from to another if there is a need and can boost performance and processing speed.

Thank you very much.