{"id":24371,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/size-database-server-1\/"},"modified":"2025-04-23T09:47:38","modified_gmt":"2025-04-23T16:47:38","slug":"size-database-server-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/","title":{"rendered":"Size of Database Server"},"content":{"rendered":"<p>The cost of the hardware must be balanced against the need to give optimal performance. In addition, increasing the speed of processor, the number of processors and increasing the amount of memory all have a positive effect on performance.<\/p>\n<h3>Number of Processors<\/h3>\n<p>ExtraView will always attempt to spread the load from concurrent user requests across all available processors in the server. Thus additional processors have a significant effect on overall performance. ExtraView transactions such as inserting or updating issues require comparatively small processing power and if they are processed in series, there is not a significant effect on performance from the perception of the user. However, if a single user initiates a complex query that takes several seconds to execute (potentially longer in a system if you are analyzing tens of thousands of records), then the processor that handles the query is not available to other users at the same time. The following chart shows ExtraView\u2019s recommendations for the number of processors to use in your main database server machine. Do not confuse the number of active user sessions with either the total number of users in your system or with the number of users signed on at the time. The number of active user sessions is the number of users who are concurrently competing for resources and attention from the processor(s).<\/p>\n<p>It is suggested that you also consult your database documentation for advice on how to best select the correct number of processors for your database server.<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ig\/system_size\/num_processors.png\" \/><\/p>\n<p>The application server may reside in the same machine as the database server and \/ or web server. ExtraView\u2019s recommendation is to use a single-processor or dual-processor computer for the application server for less than 20 (or thereabouts) concurrently connected users, but to use dual-processor computers for greater numbers. The cost of hardware is a relatively inexpensive part of the overall cost of ownership of a system based on ExtraView, and the incremental performance of good hardware will repay itself many times over, during the life of the system.<\/p>\n<h3>Processor Type and Speed<\/h3>\n<p>It is axiomatic that higher processor speeds will result in better performance. ExtraView\u2019s recommendation is to install the fastest processor you can afford, commensurate to the number of users being supported. As a rough guide, install a computer with one or more processors with a minimum speed of 2 GHz.<\/p>\n<h3>Memory<\/h3>\n<ul>\n<li><b>Database.<\/b> The database provider\u2019s recommendations for the database should be followed. ExtraView recommends 4 GB of memory or more be available for the database for small installations (less than 50 users) and at least 8 GB of memory for large installations (more than 250 concurrently connected users). Note that this is the allocation for the database only and that memory must be allocated to the operating system and other software intended to run on the server. Also note that Windows operating system servers require significantly more memory than UNIX or Linux operating systems.<\/li>\n<li><b>Web and Application Server.<\/b> This section refers to the use of Apache web server and Apache Tomcat application server. Beyond the main memory required to run the recommended Apache web server and recommended Tomcat application server, ExtraView requires an additional amount of memory for each active user session. You can consult the Apache and Apache Tomcat documentation for the precise memory requirements, but ExtraView\u2019s experience is that this is a relatively modest amount. There are two main controls for user sessions:\n<ol>\n<li>The length of time a session remains available, before the server expires the session. This is set by the application default named SESSION_EXPIRE_TIME_HOURS. The default is 8 hours.<\/li>\n<li>The behavior settings named NOSPILL_SESSION_COUNT and SPILL_SESSION_COUNT are used together to provide a tuning capability for administrators in sites where sessions may be swapped onto\/off disk. NOSPILL_SESSION_COUNT: this count defines the number of sessions to be maintained in memory. By setting this number very high, the swapping is effectively disabled, whenever the number of active sessions is unlikely to grow larger than this count. SPILL_SESSION_COUNT: this count defines where sessions must be spilled to disk; this number must be larger than NOSPILL_SESSION_COUNT. If the session count exceeds this number, session data will be spilled to disk until there are SPILL_SESSION_COUNT active sessions left in memory before any new sessions may be instantiated in memory. SPILL_SESSION_COUNT indicates the total number of sessions that may be in memory at any time. When the number of active sessions in memory is between SPILL_SESSION_COUNT and NOSPILL_SESSION_COUNT, a background task spills least recently used sessions to disk, but the creation of new sessions will not be delayed.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p>The characteristic of ExtraView\u2019s management system for the session cache is that each user session requires between 100 KB and 250 KB of memory, according to what function the user is executing at any given moment. In addition, if the user is preparing a report, the amount of memory can be considerably more in order to cache the result set of the query. This memory is only required for a short period of time while the query is executing. ExtraView automatically runs a \u201cgarbage collection\u201d routine on an internal timer to reclaim any unneeded memory and return it to the main system pool. You should provide at least 2 GB and preferably 4 GB memory for the application server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The cost of the hardware must be balanced against the need to give optimal performance. In addition, increasing the speed of processor, the number of processors and increasing the amount of memory all have a positive effect on performance. Number of Processors ExtraView will always attempt to spread the load from concurrent user requests across&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24367,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24371","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Size of Database Server - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Size of Database Server - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"The cost of the hardware must be balanced against the need to give optimal performance. In addition, increasing the speed of processor, the number of processors and increasing the amount of memory all have a positive effect on performance. Number of Processors ExtraView will always attempt to spread the load from concurrent user requests across...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-23T16:47:38+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/\",\"name\":\"Size of Database Server - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-04-23T16:47:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Installation &#038; Upgrade Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"System Size Considerations\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Size of Database Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Size of Database Server - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/","og_locale":"en_US","og_type":"article","og_title":"Size of Database Server - Product Documentation","og_description":"The cost of the hardware must be balanced against the need to give optimal performance. In addition, increasing the speed of processor, the number of processors and increasing the amount of memory all have a positive effect on performance. Number of Processors ExtraView will always attempt to spread the load from concurrent user requests across...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-04-23T16:47:38+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/","name":"Size of Database Server - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-04-23T16:47:38+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/size-database-server-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Installation &#038; Upgrade Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/"},{"@type":"ListItem","position":4,"name":"System Size Considerations","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/system-size-considerations-1\/"},{"@type":"ListItem","position":5,"name":"Size of Database Server"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24371"}],"version-history":[{"count":1,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24371\/revisions"}],"predecessor-version":[{"id":29756,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24371\/revisions\/29756"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24367"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}