When i use developer tools to analyze the network load times I see that my time to first byte is sometime 8 seconds long when loading the Index.aspx document. My pages are optimized and are never greater than 1.4 megabytes…
I have the following query which gets order data, works fine but takes 13.63 seconds: SELECT ( SELECT meta_value FROM `myprefix_postmeta` as postmeta WHERE postmeta.meta_key = '_sku' AND postmeta.post_id = woocommerce_order_itemmeta3.meta_value ) AS sku, woocommerce_order_items.order_item_name AS title, SUM( woocommerce_order_itemmeta.meta_value )…
I'm working on a toy problem: it is to make code that learns to be unbeatable at Tic Tac Toe only by playing itself. I'm a newbie to this sort of thing... I just decided that I would do it…
so I have a problem with DB migration from one webserver to another. Server 1 has MySQL version 5.6 running under cPanel hosting... Server 2 has MariaDB version 5.5 running under Webmin/Virtualmin PHP version is the same on both of…
I am making artificial intelligence bots for my private server. Their names have to be random and unique, so I made a function that retrieves a random string from a website. it takes a second to generate 3 names and…
I have a PHP script which builds a sitemap (a XML file accodring to the standard sitemap structure). My question is about improving it. As you you, a website has new posts daily. Also post may be edited several times…
I’m working within a CMS which has a limit on a include field of 32,000 characters (I can include multiple includes on each page/template). Using BEM our header/navigation element has blown the 32000 limit which has led me to question…
With PHP 7.2, each is deprecated. The documentation says: Warning This function has been DEPRECATED as of PHP 7.2.0. Relying on this function is highly discouraged. I am working on adapting an e-commerce application and converting all while-each loops to…
We have developed a website in PHP for small services. Before production, we have to do performance and load testing from server side (that is Apache) and from client side. From Client side, I want to know what is the…
at the moment I have over 150k thumbnails uploaded on my server. All 150k images are stored in different directories like this ( 2018/03/22/image1/image1.jpg ). By checking with tools like GTmetrix or PingDom I noticed that each image can be…