Currently our customers have between 10 to 100 users. A Microsoft Access database can be used for smaller companies while a SQL database is required for larger companies.
In practice Seradex ERP system performance can be continually be improved by the choice of the database, workstation, server, Ethernet switching and network equipment.
Transaction processing speed and system scalability are crucial criteria when selecting an ERP system. You need to know your new system will be able to easily handle existing transaction loads, with the ability to manage significant increases should your business experience exponential growth. Tests by Microsoft involving data entry on several core modules sales, purchasing, receivables, payables, general ledger) on the SQL database and an IBM 8500R server with eight processors simulated more than 134,000 transactions per hour being entered by more than 2,400 users.
At the volume of users and transactions included in these tests, Great Plains applications used between 16 percent and 77 percent of the available server CPU capacity, indicating opportunity for continued growth and increased scalability.