Slow initial startup time for RGP
We are experiencing a long period of time required(60-90 seconds) for RGP to load on our front desk computers. Once loaded, RGP operated lightning fast as always. As a side note, RGP loads on the server as fast as always.
This problem surfaced when replacing our back office server and our two front desk computers. All computers are running Windows 7 Professional and have plenty of memory and processing power. Windows 7 boots up nearly instantaneously.
It seems like the bottleneck must be in the SQL settings or in the firewall. Has anyone else experienced this problem?
Comments
[ALSO see replies below - it could be your internal network being slow to resolve local computer names]
This is a DNS problem with your new configuration. MySQL defaults to doing a reverse-lookup of the IP address on incoming connections. With the new server(or network configuration), this reverse DNS lookup is now taking a long time which is causing the delay on incoming connections.
You can prevent MySQL from doing this check by performing the following actions
* Run Notepad as an administrator
* Open the my.ini file in c:\program files (x86)\mysql\mysql server 5.0 . Be aware INI files are a "hidden file" and it may not be listed in the directory but you can type the name in. Additionally, the .ini bit might be hidden and you will only see the "my" part of the filename.
* Below the [mysqld] line in the file, add the line skip-name-resolve
* Save the file
* Restart the MySQL service in the Windows Service manager
If these steps are confusing, you might contact your IT person, or if you are on support, Amy can login and make these changes. Contact her directly at support@rockgympro.com
I have added the line of text and re-started MySQL as directed. We are still experiencing the same delay in the initial start up of RGP. Is there another potential problem?
Email your my.ini file (zip it please) to support@rockgympro.com so we can confirm the line is correct.
If it is, then I presume the problem is a DNS delay (a network issue on your end, not RGP) resolving the hostname of your mysql server. Have you tried connecting to the server directly by IP address rather than name?
Connecting to the IP address of the server worked perfectly. I will get everything switched over to static IPs now. Thanks Andy!!
Hi Andy, we are having the same issue, ie really slow connection times - it is taking upwards of a minute to connect to the database from each station. I have tried adding the extra line in my.ini - ie
[mysqld]
skip-name-resolve
# The TCP/IP Port the MySQL Server will listen on
port=3306
We are running an HP server with w7pro.
I would be grateful if you can advise, or expand on how to connect directly to mysql server via IP address please.
Thanks, Steve
You need to assign a fixed IP address to your server (do that in windows networking properties).
https://www.google.com/#q=assign+static+ip+to+windows+7
And then connect to the server from RGP by fixed IPs by launching the configuration wizard on each workstation for RGP.
NOTE - this delay is your local area network resolving your computer name (not RGP or MySQL). A networking person could also figure out why your name resolving is slow.
Please sign in to leave a comment.