There is a table, has 10 million records, and it has a column which type is array, it looks like: id | content | contained_special_ids ---------------------------------------- 1 | abc | { 1, 2 } 2 | abd | { 1,…
Wordpress stores both numbers and strings into Users and Posts meta tables. The issue comes when we search for meta_value: When using a number the query takes 20 times longer then same query and string. SLOW 0.73 seconds: SELECT *…
I am trying to update one table based on another in the most efficient way. Here is the table DDL of what I am trying to update Table1 CREATE TABLE `customersPrimary` ( `id` int NOT NULL AUTO_INCREMENT, `groupID` int NOT…
I'm working in a Django project and it has a postgreSQL db. I'm calling multiple times the model to filter the results: latest = Product.objects.all().order_by('-update_date')[:4] best_rate = Product.objects.all().order_by('rating')[:2] expensive = Product.objects.all().order_by('-price')[:3] But I wonder if it's better for performance and…
This is my table structure: PERSON (4.1 M rows) id : UUID notes: string ... --- ATTRIBUTES (21 M rows) id: UUID person_id: <persons id> non null name: ENUM : full_name | birthday | email | phone | photo value:…
I have a single table with ~ 1.5 mio entries and this query: SELECT id FROM abc.items as I where revisit < '2022-11-17T00:00:00Z' AND type = 10 AND firstdelivery = ( select min(firstdelivery) from abc.items WHERE I.polizzennummer = polizzennummer )…
I am running a simple query to get the max ID in a table: SELECT max(ID) FROM t WHERE m=345; Table (t) has 20 million records and 2000 distinct values for m. There is a primary key index on ID…
I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that…
here I have tried to rewrite the query with cte cuz of good readability but when I try to rewrite the data is mismatched how to solve the problem for this? Query; select count(1) as rage_tap from ue_summary.summary_funnel_1066 s join…
I have this query to fetch most recent conversations grouped by phone number, however the query time is too slow. How can it be faster? SELECT * from messages WHERE id IN (SELECT max(id) from messages GROUP BY phone) AND…