• From: Austria
  • Registered: 01/05/2013
  • Posts: 29

Topic: Companies, how many is reasonable

One can make more companies in FA, in the DB you get a number for the set of tables.

I am wondering how many can be made 10 or even more?

What is an acceptable number.

Regards,
Jan

janvl's Website

2 Reply by apmuthu (edited by apmuthu 12/19/2016 09:12:50 am)

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

Re: Companies, how many is reasonable

You can store one company per DB or many companies in a single DB with prefixes - prefixes are recommended for security and inadvertant overwriting on wrong company restoration.

The InnoDB engine will need to be large enough to accomodate all the InnoDB tables in all the DBs of the server unless the InnoDB per-table settings are configured. Filesize per file on the OS should also be considered (32 bit limitations, etc).

The size of the data will vary with each company's transaction volume and document attachments.

Servers with upto 10 companies (_0 to _9 prefixes) with transaction volumes to fit into a virtual instance of say 10 GB with 2 fiscal years in open state with 3 users each and not much document attachments can be a ball park figure. The total number of active simultaneous users will be important too as will be bandwidth available and latency, CPUs / speed, RAM and other hardware considerations.

PlaNetTel supported FrontAccounting OpenVZ containers on Debian Squeeze (yes it's old) with 8GB VDisk / 1GB RAM, comes pre-installed with 10 company databases for use with any prefix in each to enable restoration from any other install / prefix.

apmuthu's Website