I am looking for a way faster solution to split a string into an array of values. The string has unfortunately ; as a delimited character. Split seems to be quite slow when it comes for a set of >…
I need help with MariaDB server optimization. I have a lot I/O operations (created tmp disk tables) and I want to reduce it. Hardware: CPU 20 x 2197mHz, RAM 50 Gb, SSD disks RAID 10 Software: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1…
Since about 2 months ago, I've experienced my website slows down (timeout problem), however I've made some checking on the server and my settings and behavior is this (LAMP, VPS 6GB Ram - 4 cpu cores, but I'm not expert…
I have started working with images and currently I am trying to rescale and grayscale an image (Size 6000x4000 -> 600x400) to better work with it. For this I am using Numpy and PIL.Images. import PIL.Image as Img import numpy…
I've been at this for a few days now trying different methods to reduce the 95-135% CPU load due to a recent AJAX script, calling this query: SELECT COUNT(*) as total FROM users WHERE last_access >= DATE_SUB(NOW(), INTERVAL 1 MINUTE)…
We're running a custom ad server solution and, in some cases, we store and increment/decrement counts and aggregated values in MySQL, for optimization. I understand keeping counts in MySQL is not ideal, although I'm not 100% sure why. My guess…
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance. The schema is set up as a Many-To-Many Polymorphic relationship. I have a Videos table that contains video…
I have a join query which takes a lot of time to process. SELECT COUNT(c.id) FROM `customers` AS `c` LEFT JOIN `setting` AS `ssh` ON `c`.`shop_id` = `ssh`.`id` LEFT JOIN `customer_extra` AS `cx` ON `c`.`id` = `cx`.`customer_id` LEFT JOIN `customers_address`…
Please, help me with this code. It runs very slow, about 2 minutes. I'm new to js and don't know how to improve it. I need to take data from multiple ajax requests and compare it. I tried to use…
I am struggling to fix wordpress website speed issue in mobile. Mobile speed is 43 wheareas desktop speed is 93 I see the main problem is from Preload key requests time. That problem is coming from Elementor plugin fonts used…