Many factors can be the cause of database slowdown. We have checked our work and excluded the reasons that can negatively affect the speed of the database.
Therefore, we suggest that you check your IT infrastructure to find and, if possible, resolve the factors that lead to slow system performance.
1.Running 1C in a thin client:
If you work in 1C:FirstBit system via web-browser, it is recommended to install thin client (1С desktop application), as it works faster and more efficiently than via web-browser.
If you need to install 1С desktop application on your computer, you can create request to Hotline and our consultants will help you with the installation.
2. 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 probably have a lot of documents in them from previous years, this slows down the system a lot.
3. Sheduled and Background Jobs
Note: Please keep in mind that you can only perform these items if you have ERP data base configuration, in base with Accounting configuration the control and configuration of Sheduled and Backgrounds Jobs is done on the FirstBit side.
3.1. Background Jobs.
Open Administration - Sheduled and Background Jobs:
Open the background jobs tab and analyze which jobs are failed to execute or canceled by the program or by the user.
In the screenshot below, you can see how to set filters to find such jobs. Double-click to open it and you can see the details of each error.
3.2. Sheduled Jobs.
Check background processes in your 1C:FirstBit database and make settings for their shedule:
Some jobs can be rescheduled to a more convenient time so as not to slow down the database during an active workday. For some jobs, you can set a longer interval between each repeat, which will also help to relieve the database.
4. 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.
4.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.
4.2. If you work through a browser, it is necessary to clear the browser cache.
To detect and correct the causes of slow system performance, please check the following parameters of your IT infrastructure, some of this actions may require the assistance of your IT specialists.
5.Network parameters:
5.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 provider to speed up your Internet connection.
6.Computer parameters:
Check computer or laptop parameters (model of processor, RAM value and running version Operating System), if you have RAM less than 16 Mb or CPU frequency less than CPU frequency is less than 3,5 Ghz, you need to upgrade your hardware.
6.1.1. If you have device running on OS Windows:
6.1.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:
6.2. Disk Space: Additionally, you should check how much free space is left on the system disk. Free space is needed for creating a swap file and saving cache files, if there is not enough free space, you should free it by deleting unnecessary files.
Do this under the supervision of your IT specialist so as not to disrupt the performance of your computer.
6.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. 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).
6.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.
6.3.2 Add site address to trusted (to exceptions) if Web-browser is used
7. 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.
7.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
Note: 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.
7.2. For MAC OS:
View CPU activity in Activity Monitor on Mac
In the Activity Monitor app on your Mac select CPU, Memory, Disk or Network tab to see its performance parameters:
Thanks for being a Firstbit Customer! #Slow database #Ways to run database smoothly.