Many factors can cause a database's slowdown. We have checked the work from our side and excepted the reasons that can have a negative impact on the speed of the database.
Therefore, we suggest you to check your IT infrastructure to find and if possible fix the factors that lead to slow operation of the system.
To detect and correct the causes of slow system performance, please check the following parameters of your IT infrastructure, some of them may require the assistance of your IT specialists.
1.Network parameters:
1.1 Check the speed of the network connection - go to the service site speedtest.net.
Here is example of the checking on the screenshots below.
If your network speed is les than 50 Mbps you need to discuss it with your INTRTNER prowider to speed up your Internet connection.
2.Computer parameters:
Check computer or laptop parameters (model of processor, RAM value and running version Operating System), if you have RAM less than 8 Mb or processor less than , you need to upgrade your hardware.
2.1. If you have device running on OS Windows:
2.2 If you have MacBook device: on the Mac, click the Apple menu in the upper-left corner of the screen and choose About This Mac. A window opens, displaying version of the running mac OS, and information about Processor and RAM:
3. Checking Antivirus settings.
Despite the fact that antivirus is one of the important programs that protects data from the harmful codes, it can slow down the work of 1C. As a rule, this is the most common cause of program slowdowns and freezes. To avoid this, you should set up exceptions - make it so that the antivirus does not check files with the 1C database.
Make antivirus settings to exclude 1C programs from scanning if you need it to speed up the work of database (this is an example of Droctor Web antivirus settings, but all antiviruses have similar exclusion settings logic, to configure other antiviruses, see their documentation).
3.1 Add to trusted applications, if using Thin Client
Find application on your computer and add it to the list of exclusions.
Note: When you update or install new version of application you need to add it to exclusion.
3.2 Add site address to trusted (to exceptions) if Web-browser is used
4.Running 1C in a thin client:
4.1. If you work in 1C FirstBit system via web-browser, it is recommended to install thin client (1С desktop applacation), as it works faster and more rationally than via web-browser.
5. Other Programms working on your device (PC or Laptop).
You need to check what other programs are installed on your workplace besides the 1C client. If there are programs installed on the computer (laptop) that consume a lot of memory and processor resources, or have a large exchange of data over the network, it may negatively affect the performance of the database. It is recommended to move such programs to another computer.
5.1 For Windows OS:
Running Programms: to check which programs are currently running and how many resources they are consuming, you need to call Task Manager, as shown in the screenshots below. It will help you evaluate which programs are consuming too much memory or loading the processor:
Installed programms: To check what programs are installed on your computer and assess which ones are needed and which ones can be moved to another computer, open Control Panel - Programs as shown in the screenshots below (keep in mind that installation/uninstallation of programs from your computer should only be done by an IT specialist, otherwise, removal of vital programs may disrupt the overall performance of your computer).
5.1 For MAC OS:
View CPU activity in Activity Monitor on Mac
Most of the time, the processor on your Mac uses only a small percentage of its processing power. When you use apps that require intensive calculation, the processor uses more of its capacity.
To enable viewing in the Dock, choose View > Dock Icon, then select the Show CPU option you want to view.
In the Activity Monitor app on your Mac, do any of the following:
To view processor activity over time, click CPU. The following percentages appear at the bottom of the Activity Monitor window:
System: The percentage of CPU capability that’s being used by processes that belong to macOS.
User: The percentage of CPU capability that’s being used by apps you opened, or by the processes opened by those apps.
Idle: The percentage of CPU capability that’s not being used.
To view current processor activity, choose Window > CPU Usage.
To view recent processor activity, choose Window > CPU History.
To display more columns, choose View > Columns, then choose the columns you want to show.
6. Useless Data in Cache.
Often the cause of glitches and slowdown of the database is a messed up 1C cache. Cleaning the cache very often leads to restoration of adequate performance of the database.
We have a manual on how to Clear Cache, but you can use a simpler method.
1. The following method of cache cleaning is suitable if the client works through the application:
You need to start the database, having previously set the /ClearCache key in the startup parameters.
It is necessary to keep in mind:
1- after a single start the cache will be cleared and this key can be removed from the startup parameters, because if you constantly start with this key, the startup will last longer than without it;
2- if the client has several bases, then it is necessary to start each base with this key, because at startup only the cache of one particular base is cleared.
2. If the client works through a browser, it is necessary to clear the browser cache.
7. Check background processes in your 1C:FirstBit database and make settings for their shedule:
8. Setting of additional filters to narrow down the search area.
Please, note, that it is very important to set filters to every user, because, full searching from even one User affects other Users. It takes a lot of RAM on the Server’s side, and you have many documents in the system.
The manual is in the link: Configure List Option (Filter)
You will be able to pull any field to the header and then search for it. Therefore, system will search information only in companies’ column, and you may set the same for almost every column. It will help to fix the issue with slowness.
When you are searching everywhere, since there are many documents, the system might slow down. You can see it in logs, that searching leads to errors:
Please try the following steps in addition: Set the periods in documens lists, as you have a lot of documents in them from 2017, this slows down the system a lot.
Thanks for being a Firstbit Customer! #Slow database #Ways to run database smoothly.