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…
I have a table such as follows: CREATE TABLE Associations ( obj_id int unsigned NOT NULL, attr_id int unsigned NOT NULL, assignment Double NOT NULL PRIMARY KEY (`obj_id`, `attr_id`), ); Now the insertion order for the rows is/will be random.…
Here is the table data id time amount 1 20221104 15 2 20221104 10 3 20221105 7 4 20221105 19 5 20221106 10 The id and time field is asc, but time can be same. The rows are very large,…
I'm trying to make a very simple query to a MySQL 5.7 database but the query is slow and the explain shows it is not using the index, although it lists it as a possible key. Below is the query,…