I'm trying to figure out why a simple select with a LIMIT 1 clause (admittedly, on a really bloated table with a lot of rows and indices) is sometimes taking 30+ seconds (even 2 minutes, sometimes) to execute on an…
I have a query that takes 0.0002s in PHPMyAdmin and takes hundreds of seconds if I do it from PHP. Here it is: SELECT id, id_pages, link, childlink, url, hiddencontent, cansearch, ( SELECT p.id FROM pages as p WHERE pages.hiddencontent=1…
I have a PHP application that is running on a LAMP stack. This application makes an API call back to the server via javascript to get more data to display on the screen every second. When there are a number…
There are 2 samples. In the first example, it gives faster results when using orderby. (according to phpmyadmin speed report) In the other example, I don't use order by, it gives slower results. (according to phpmyadmin speed report) Isn't it…
I have a table, with string on one of the columns, the format of the string is ISO 8601 (with TZ). When I'm trying to run the following query: select * from `orders` where STR_TO_DATE('last_ship_date', '%Y-%m-%dT%TZ') >= STR_TO_DATE('2020-06-27 21:13:14', '%Y-%m-%d…
Besides having mariadb 10.1.36-MariaDB I get following error. EXPLAIN ANALYZE select 1 MySQL said: Documentation 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to…
Clearly, adding indexing to Mysql tables speed up access. Does WordPress generates this simple optimization or should I perform it manually, or use one of the many optimizations plugins? For example: in phpMyadmin all you need is to select table…