Topic: Local Server Requirements

Hello,
I need to install FA in a local network powered by Windows with more than 100 Users.

What should be configuration of Local Server to host FA with this number of users.

Any Ideas?

www.boxygen.pk

Re: Local Server Requirements

If you are using XAMPP, then only a 32 bit version is available so more than 3.2 GB RAM is meaningless.
You can however, use VMWare Player to run 64 bit Debian/Ubuntu/CentOS, etc., inside Windows, whilst all your end users can be on Windows browsers.

100 Users or 100 concurrently using clients?

They can be normal hardware with 16 GB Win2012R2 running IIS if you need to run FA on the host itself.

Re: Local Server Requirements

I need 100 users on 100 work stations concurrently accessing FA installed on the server in LAN

www.boxygen.pk

Re: Local Server Requirements

PHP and Apache don't have official supported 64 bit Windows builds.
Only MySQL out of the three does, hence no 64 bit bundle for XAMPP on Windows.

However, the current versions of PHP seem to have some 64 bit builds at https://windows.php.net/.

Processors, manufactured after 2011, most likely support AVX and it's PHP builds. The exact information about the hardware can be retrieved by using the Coreinfo tool.

Current Apache for Windows 64 bit are available at Apache Lounge.

In spite of all the above, give the 32 bit version of XAMPP a try on Win 10 with the specs in my previous post and provide benchmarks on actual concurrent usage and load factors in your network.

5 (edited by poncho1234 12/10/2018 03:00:21 am)

Re: Local Server Requirements

If its any help Wampserver has a 64 bit version. Though you do have to install both 32 and 64 bit versions.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Local Server Requirements

Yes, It sports the following in WAMP 3.0.6:

Apache 2.4.27
PHP 5.6.31, 7.0.23, 7.1.9
MySQL 5.7.19
MariaDB 10.2.8
PhpMyAdmin 4.7.4 
Adminer 4.3.1
PhpSysInfo 3.2.7

Wampserver 2.5 onwards are not compatible with

Windows XP, not even with SP3
Windows Server 2003

and they also require a disk formatted as an NTFS partition, and does not support FAT32 or exFAT.

Caveats:
If you install Wampserver over an existing version, not only it will not work, but you risk losing your existing databases. Also install it in a root folder like C:\wamp or d:\wamp . Close Skype or force not to use port 80 before installation and while WAMP is in use.

WAMP 3.1.4 was released on 2018-09-25.

Re: Local Server Requirements

You might require a server with 8gm ram, and 512gb SSD and Intel Xeon E3 Processor or more than that.

Basically you need server  like Dell flagship or ibm series  to handle 100  concurrent users

Subscription service based on FA
HRM CRM POS batch Themes

Re: Local Server Requirements

Thanks all for your input. I will post my feedback once done

www.boxygen.pk

Re: Local Server Requirements

@boxygen I used this StackOverFlow post

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/