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…
SELECT u.ID, u.display_name as name, u.user_email as email, u.user_registered as registered, ( select meta_value from wp_usermeta where user_id = u.ID and meta_key = 'mobileno' limit 1 ) as mobileno, ( select meta_value from wp_usermeta where user_id = u.ID and meta_key…
The background task I am running in my asp.net application is taking long time to execute and is getting stuck at a linq query.How to optimize the linq query or can you suggest some alternatives so that this method or…
I'm making one custom app that already has over 10.000.000 users. I had to create one custom query that extracts users from a specific member type. The problem is if I want to see only 20 users and do pagination,…