OI "capacity" (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== OI "capacity" (OpenInsight Specific) ====
=== At 25 FEB 1999 08:45:36PM Bill Maher wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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?
</QUOTE>
----

=== At 01 MAR 1999 03:05AM Nick Stevenson wrote:  ===

<QUOTE>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.



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=34C7C42A03F8DA14852567240009AB08|View this thread on the  forum...]]