OI "capacity" (OpenInsight Specific)
At 25 FEB 1999 08:45:36PM Bill Maher wrote:
To all OI developrs:
What/who are among the "larger" OI apps existing as it pertaisn to the number of concurrent users and numbers of files open? Are these apps running over a WAN on NT or Netware? Are any of them using an ODBC connect to SQL Server?
At 01 MAR 1999 03:05AM Nick Stevenson wrote:
Our largest OI site is as follows:
Number of forms: 991
Number of stored procedures: 1069
Number of tables: 489 (including indexes)
NOS: Novell IntraNetware 4.11
PCOS: Windows 95
Servers: Compaq Proliant
OI: Version 3.6.1, NLM V 1.5
7 databases, connected via WAN (slowest is 64kb thru 512kb)
Main database statistics (others are similar, but reducing in size)
Peak file variables: 151
Peak file handles: 527
Peak locks: 43
Peak clients: 54
We have about 30 users coming in via Citrix Winframe (which registers only one client in the NLM stats) - which puts the current peak clients up to around 84.
Data Warehousing to MS SQL Server of data from all 7 databases into centrally located SQL database. DW is done using UPDATES-ONLY for all databases, and runs once a day (at 1.00AM).
Indexing is done via dedicated index servers (2 at the main sites, 1 at the smaller sites).
System is very stable - no GFE's at all excepting when a server crashes thru power failures (and then only on indexes). Performance is adequate to good over the WAN (depending on line bandwidth). Have had peaks of over 100 concurrent users on a single server in the past, with little degredation in performance.