Lentezza apertura Facile su Windows Server 2019

Manlio Morini reporter

Il problema non è legato a Facile o a Windows Server 2019.

Bisogna rifarsi alla checklist di Firebird:

Why is the connection to the server so slow?

There are various reasons. Here's a checklist:

Are you using hostnames or IP adresses. It might simply be a DNS resolving issue on either server or client. The client needs to resolve server name to IP address in order to access it. The server needs to resolve client's IP address into name to put it in firebird.log file.
Things that help include proper setup of local DNS server, changing the connection string from server name to IP address or vice versa, and adding client/server to each other's hosts files. On Linux the host file is typically located in /etc/hosts, while on Windows the location differs (try c:\windows\system32\drivers\etc\hosts).
If you have CPU that supports hyperthreading try disabling it to see if that helps. If you can multi-core CPU (dual core, quad core), set the CPUAffinity setting in firebird.conf
If you are using Windows XP or 2003 or any other that has system recovery, it is advisable to turn it off for the drive where Firebird database is stored. The main problem is that Windows considers that files with .gdb extension are system files and need to be backed up on each write. Newer versions of Firebird use .fdb for security database, and you should use .fdb as extension for your own databases to prevent these problems.
[cut]

‌

2022-07-26T13:57:09+00:00

Comments (3)

Manlio Morini reporter
Il problema è stato ricondotto alla FormImpostazioni. Sono necessari nuovi strumenti per il debug.
- 2021-10-26T10:15:37+00:00
Manlio Morini reporter
Il problema non è legato a Facile o a Windows Server 2019.

Bisogna rifarsi alla checklist di Firebird:

Why is the connection to the server so slow?

There are various reasons. Here's a checklist:
1. Are you using hostnames or IP adresses. It might simply be a DNS resolving issue on either server or client. The client needs to resolve server name to IP address in order to access it. The server needs to resolve client's IP address into name to put it in firebird.log file.
  Things that help include proper setup of local DNS server, changing the connection string from server name to IP address or vice versa, and adding client/server to each other's hosts files. On Linux the host file is typically located in /etc/hosts, while on Windows the location differs (try c:\windows\system32\drivers\etc\hosts).
2. If you have CPU that supports hyperthreading try disabling it to see if that helps. If you can multi-core CPU (dual core, quad core), set the CPUAffinity setting in firebird.conf
3. If you are using Windows XP or 2003 or any other that has system recovery, it is advisable to turn it off for the drive where Firebird database is stored. The main problem is that Windows considers that files with .gdb extension are system files and need to be backed up on each write. Newer versions of Firebird use .fdb for security database, and you should use .fdb as extension for your own databases to prevent these problems.
4. [cut]
‌
- 2022-07-26T13:57:09+00:00
Manlio Morini reporter
- changed status to closed
- 2022-07-26T13:57:36+00:00
Log in to comment