Bug #77222 [Asn->Csd]: memory_limit Greater then 64M slows down reply

Edit report at https://bugs.php.net/bug.php?id=77222&edit=1 ID: 77222 Updated by: cmb@php.net Reported by: jpmiguel at yahoo dot com Summary: memory_limit Greater then 64M slows down reply -Status: Assigned +Status: Closed Type: Bug Package: IIS related Operating System: Windows 2008 RC2 PHP Version: 7.2.12 Assigned To: cmb Block user comment: N Private report: N New Comment: > I managed to pinpoint and solve the problem. Great! Thanks. Previous Comments: ------------------------------------------------------------------------ [2020-04-08 12:15:15] jpmiguel at yahoo dot com Hi, I managed to pinpoint and solve the problem. When importing the database I activated the lower case on table names. And in the php configuration was in upper case. The site still works fine without problems or errors but it takes two times the normal time to send the page to the user. Just by changing the Database and table names back to Upper case it started rendering the pages within a second. ------------------------------------------------------------------------ [2020-04-08 11:18:03] cmb@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2018-11-30 03:00:57] jpmiguel at yahoo dot com Description: ------------ I have a server using php-cgi on a new site we are putting on production. And it behaves very poorly with around 4 seconds before the first reply. After the php delivers the html the page and all the scripts and images load almost instantly. After some tweaks I realized that if I lower the memory-limit below 64M on the php.ini it behaves much better (0.6 seconds). But I cant keep the memory limit that low because I will get "Allowed memory size of 67108864 bytes exhausted" from time to time. Can you please check or point me on a way to solve this? Thanks ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=77222&edit=1