I am currently working on a project that has 2 very large sql tables Users and UserDocuments having around million and 2-3 millions records respectively. I have a query that will return the count of all the documents that each…
Tell me how to optimize the deletion of data from a Postgre table I have a table like this: CREATE TABLE IF NOT EXISTS test ( group varchar(255), id varchar(255), type varchar(255), ); INSERT INTO test (group, id, type) VALUES…
The below query is taking time to execute. does this have any rewrite possibilities? Query; SELECT t_product.a_productid, t_product.a_mpactive, t_product.a_active, trim( substring_index(a_reference, '_',-1)) as a_reference, t_product.a_shopid, t_productlang.a_name, t_deactivatedproduct.a_reason FROM t_deactivatedproduct inner join ( SELECT max(a_deactivatedproductid) as a_deactivatedproductid FROM t_deactivatedproduct GROUP by…
I know that this MariaDB version 5.5.68 is really out of date, but I have to stay with this old version for a while. Is there a way to prevent toxic selects, possibly blocking MyISAM tables for a longer time…
This query has so many joins and i have to apply conditions on joined table columns to get the desired results but query becomes slow when i apply condition on a datetime column. Here is the query select distinct v0_.id…
I'm not clear how to search for this, if there's a duplicate feel free to point me to it. I'm wondering if there's a way to tell mysql that something will be sorted before filtering so that it can perform…
I am using tableau for a dashboard that pulls data in from a MySQL database. It works perfectly but the query takes too long to execute. The data is limited to the previous 2 years and the most recent Saturday…
⛰️ Hi comunity, I'm using a normal MySQL query to join 2 tables. My query in a simpler way looks like these (for these example i just put *, otherwise i have targeted elements) SELECT table1.*, table2.* FROM table1 INNER…
I have a table with these columns: id (int) col1 (int) col2 (varchar) date1 (date) col3 (int) cumulative_col3 (int) and about 750k rows. I want to update the cumulative_col3 with the sum of col3 of same col1, col2 and previous…
I'm working on a rights verification system. In order to verify that the user has access to the documents, I make a request to the database There are 2 cases when you can get access: The user is in the…