Question Deleting a single entity requires more than 20 seconds of waiting

Hello, My current tree has more than 60,000 records. When adding data, it takes less than 1 second, but it takes more than 20 seconds to delete an individual record. This time is really driving me crazy.
My tree is used locally. The computer configuration is win10\i7\8G memory\500G SSD hard disk.
Please ask this.
webtrees 2.1.22

Your hardware and OS seem up to the task.

Can you share some information about the PHP server configuration, in particular the database? Do I understand correctly webtrees runs on your own machine, not on a server somewhere in the cloud on the internet?

Do you use WAMP or XAMPP, what version exactly? How is the database configured?

Hello,
Yes, my tree is running on my own computer.
my system: win10+mysql 5.6.24, IIS8, php7.4.9

 
 

according to your Config, you use PHP Thread Save for a Windows Desktop installation. I believe you are only using it as a single concurrent user. 

I have been using webtrees for over 15 years on Windows servers with PHP Non Thread Safe (NTS) for multiple concurrent users without any problems.

Try an NTS version of PHP, preferably 8.4.2 (VS17 x64 Non Thread Safe (2024-Dec-17 17:33:30) from windows.php.net/download/ ), which should also be compatible with 2.1.22 ( webtrees.net/install/requirements/ ).

PHP 8.x is no longer directly supported by Microsoft. If you need help configuring it, don't hesitate to contact me.

When there are only about 30,000 records, I don't feel the change in the time required to delete an individual. When there are about 50,000 records, I clearly feel that the time required to delete has increased.
This problem only occurs when deleting individuals and families.
If it is a query, even if there are 500+ records returned, the time consumption will be around 3s.

This is not normal.

I have used a site with 1000000 individuals, and it takes less than a second.

1) Look at your MySQL configuration? Perhaps you need to allocate more memory?

2) You are using a very old version of MySQL. Newer versions have better performance.

Thank you. I upgraded mysql8\IIS today, and the time required to delete an individual item was reduced from 20 seconds to about 6 seconds, which is an improvement, but it still takes a long time.

 

Warius wrote:

according to your Config, you use PHP Thread Save for a Windows Desktop installation. I believe you are only using it as a single concurrent user. 

I have been using webtrees for over 15 years on Windows servers with PHP Non Thread Safe (NTS) for multiple concurrent users without any problems.

Try an NTS version of PHP, preferably 8.4.2 (VS17 x64 Non Thread Safe (2024-Dec-17 17:33:30) from windows.php.net/download/ ), which should also be compatible with 2.1.22 ( webtrees.net/install/requirements/ ).

PHP 8.x is no longer directly supported by Microsoft. If you need help configuring it, don't hesitate to contact me.

Currently, I am using Wamp with PHP 8.4.2 (thread safe). I am curious if the NTS version would provide better performance and downloaded 8.4.2 NTS. However, I was not able to get it running in Wamp. There are only 3 different files in the NTS download compared to the installed 8.4.2 files. I copied the phpForApache.ini file from 8.4.2 to 8.4.2 NTS and adjusted the pathes. However, always got Apache errors.

From the Wamp documentation, I guess that 8.4.2 NTS needs to be started in FCGI mode. Therefore, I tried to configure a virtual host with FCGI and 8.4.2 NTS. However, also not working.

Does someone have experiences with NTS versions in Wamp?
In general: Is it possible to install other PHP version than the supported Wamp PHP versions?
Any hints?

Maybe this will help - here is an excerpt from the IIS 10 applicationHost.config (I use 2 mostly identical PHP installations for production and debugging with one PHP.ini and different ini extensions)

        <fastCgi>
            <application fullPath="C:\PHP\PHPProd\php-cgi.exe" monitorChangesTo="C:\PHP\PHPini\php.ini" activityTimeout="300" requestTimeout="300" instanceMaxRequests="10000">
                <environmentVariables>
                    <environmentVariable name="PHPRC" value="C:\PHP\PHPini\php.ini" />
                    <environmentVariable name="PHP_INI_SCAN_DIR" value="C:\PHP\PHPini\PHPProd" />
                    <environmentVariable name="PHP_FCGI_MAX_REQUESTS" value="1000" />
                </environmentVariables>
            </application>
            <application fullPath="C:\PHP\PHPDev\php-cgi.exe" arguments="" monitorChangesTo="" stderrMode="ReturnStdErrIn500" maxInstances="4" idleTimeout="300" activityTimeout="900" requestTimeout="900" instanceMaxRequests="200" signalBeforeTerminateSeconds="0" protocol="NamedPipe" queueLength="1000" flushNamedPipe="false" rapidFailsPerMinute="10">
                <environmentVariables>
                    <environmentVariable name="PHP_INI_SCAN_DIR" value="C:\PHP\PHPini\PHPDev" />
                    <environmentVariable name="PHPRC" value="C:\PHP\PHPini\php.ini" />
                    <environmentVariable name="PHP_FCGI_MAX_REQUESTS" value="10000" />
                </environmentVariables>
            </application>
        </fastCgi>

        <handlers>
            <add name="PHPProd" path="*.php" verb="GET,HEAD,POST" modules="FastCgiModule" scriptProcessor="C:\PHP\PHPProd\php-cgi.exe" resourceType="Either" requireAccess="Script" />
          </handlers>

     <location path="WTDev">
        <system.webServer>
            <handlers>
                <remove name="PHPProd" />
                <add name="PHPDev" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\PHP\PHPDev\php-cgi.exe" resourceType="File" />
            </handlers>
        </system.webServer>
    </location>
    <location path="FFProd">
        <system.webServer>
            <handlers>
                <add name="PHPProd2" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\PHP\PHPProd\php-cgi.exe" resourceType="File" />
            </handlers>
        </system.webServer>
    </location>
    <location path="WTProd">
    </location>