{"id":23389,"date":"2017-08-16T16:12:19","date_gmt":"2017-08-16T20:12:19","guid":{"rendered":"https:\/\/onpremise.inflowinventory.com\/support\/?p=23389"},"modified":"2024-06-21T08:59:42","modified_gmt":"2024-06-21T12:59:42","slug":"inflow-slow-taking-long-time-load-data-can","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/23389\/inflow-slow-taking-long-time-load-data-can\/","title":{"rendered":"inFlow On-Premise is slow \/ taking a long time to load data. What can I do?"},"content":{"rendered":"<p>There are several issues that can cause slow performance or problems loading data in inFlow On-Premise.<\/p>\n<h2>Hardware<\/h2>\n<p>Your server computer should have 4GB RAM at minimum, though the more the better! You can check this in <em>Start &gt; Control Panel &gt; System and Information &gt; System<\/em>. A high processor speed also helps. Please refer to our <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/41566680\/what-are-the-minimum-requirements-needed-to-run-inflow\/\">minimum requirements here<\/a>.<\/p>\n<p>If you&#8217;re under 4GB RAM, you&#8217;ll need to upgrade it as it will be too slow for inFlow to perform tasks like loading a list of your products, generating reports, etc.<\/p>\n<h2>Network speed<\/h2>\n<p>When you use inFlow&#8217;s multi-user mode, it relies on your network connection to load the data on client computers. To determine if it&#8217;s your network that&#8217;s causing the issue, try loading an order on the server computer and see how long that takes, and compare it with loading the same order on a client computer.<\/p>\n<p>It&#8217;s hard to gauge your network speed, but if you notice that your speed is slow, you may want to check with the person who set up your network.<\/p>\n<h2>Negative inventory<\/h2>\n<p>inFlow isn&#8217;t designed to work with negative inventory &#8212; every time you update an item that has negative inventory, inFlow has to recalculate all of the transactions starting from that point it reached negative inventory. So if you&#8217;ve never added stock \/ adjusted stock to deal with the negative inventory, then it will do a lot of extra work for that calculation.<\/p>\n<p>To check if you&#8217;ve got lots of negative inventory, go to\u00a0<em>Main Menu &gt; Inventory &gt; Current Stock<\/em> and sort by <em>Quantity<\/em>. \u00a0If you have any negative inventory, count the physical quantity and update that in inFlow.<\/p>\n<h2><b>Database size<\/b><\/h2>\n<p>If you&#8217;ve been using inFlow for a really long time now and your database is growing too big, you might run into issues with performance.<\/p>\n<p>You can check the size of your database files\u00a0here:<\/p>\n<p><strong>Windows XP\/Server 2003:<\/strong>\u00a0<code>C:\\Documents and Settings\\All Users\\Application Data\\inFlow Inventory<\/code><br \/>\n<strong>Vista, Windows 7\/Server 2008, Windows 8\/ Windows 10:\u00a0<\/strong><code>C:\\ProgramData\\inFlow Inventory<\/code><\/p>\n<blockquote><p>PLEASE NOTE: If you\u2019re not able to see the folders outlined below please follow these steps to show hidden files\/folders:\u00a0<a href=\"https:\/\/www.microsoft.com\/resources\/documentation\/windows\/xp\/all\/proddocs\/en-us\/win_fcab_show_file_extensions.mspx?mfr=true\">Windows XP<\/a>,\u00a0<a href=\"https:\/\/www.bleepingcomputer.com\/tutorials\/how-to-see-hidden-files-in-windows-vista\/\">Vista<\/a>,\u00a0<a href=\"https:\/\/www.bleepingcomputer.com\/tutorials\/show-hidden-files-in-windows-7\/\">Windows 7<\/a>,\u00a0<a href=\"https:\/\/www.bleepingcomputer.com\/tutorials\/show-hidden-files-in-windows-8\/\">Windows 8<\/a>,\u00a0<a href=\"https:\/\/www.isunshare.com\/windows-10\/show-hidden-files-and-folders-in-windows-10.html\">Windows 10<\/a>.<\/p><\/blockquote>\n<p>Look for a file that says inFlow.mdf (or just inFlow). You should see its size next to it. (For reference, 1GB = 1024MB = 1,048,576 KB!)<\/p>\n<p>You can expect to see some slowness around 4GB or so, depending on your hardware.<\/p>\n<p>If your database is nearing 10GB, you will\u00a0need to <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/41559280\/how-do-i-archive-my-database\/\">archive your database<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several issues that can cause slow performance or problems loading data in inFlow On-Premise. Hardware Your server computer should have 4GB RAM at minimum, though the more the better! You can check this in Start &gt; Control Panel &gt; System and Information &gt; System. A high processor speed also helps. Please refer to [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,23],"tags":[125,49,124,127,126],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/23389"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=23389"}],"version-history":[{"count":8,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/23389\/revisions"}],"predecessor-version":[{"id":30034,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/23389\/revisions\/30034"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=23389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=23389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=23389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}