The section fronts on a Wordpress site I help out with have just started loading slow, and I traced it to the SQL query that loads the posts for the page, and timed a few different queries to see what's…
I'm having problems with a slow SQL query running on the following system: Operating system: Debian 11 (bullseye) Database: MariaDB 10.5.15 (the version packaged for bullseye) The table schemas and some sample data (no DB Fiddle as it doesn't support…
I want to know if one of the promises fail how can i rollback or cancel already happened operations. and 2nd is there any other way to optimize code, it takes more time to resolve. As the number of joined…
I have a table with a column that contains mobile numbers, this table has about 40 millions records. this is the table schema with some dumping data query -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host:…
UPDATE: seems that the Query Cache is not activated, otherwise the performance would be much better from the second execution of the same query, since MySQL should have cached it already. I have MariaDB version: 10.2.41- Protocol version: 10 ,…
const score_schema = mongoose.Schema( { tester_id: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true, }, test_id: { type: mongoose.Schema.Types.ObjectId, ref: "test", required: true, }, score: { type: Number, required: true, }, }, { collection: `score`, timestamps: true, } ); query 1:…
Essentially, there are 2 queries. The first one queries a collection_A and then return an array of _id. The second query will use this array in a $in operator to query collection_B. How can this be done in just 1…
I have the following query, which currently takes about 0.3s to load, causing a heavy load on my Wordpress site. SELECT SQL_CALC_FOUND_ROWS wp11_posts.ID FROM wp11_posts WHERE 1=1 AND ( wp11_posts.ID NOT IN ( SELECT object_id FROM wp11_term_relationships WHERE term_taxonomy_id IN…
I have a large Wordpress site with 170.000 users and a lot of daily page views. I just tuned all MySQL indexes based on several comments but actually in my slow logs the SELECT distinct wp_usermeta.meta_key FROM wp_usermeta; takes around…
Recently I have have received under my responsibility the company's wordpress site, suffers from extreme performance issues... I have started investigating, installed Query Monitor and discovered several problemas: Get_terms(). The site's theme use heavily this method in many shortcodes. All…