I have 2 tables arh and ar .I need to delete records from arh table for each accountMappingId where actionRequestId is <= maximum actionRequestId for the operation 'RESTORE' on the equivalent mappingId in ar table. The records should be deleted…
this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…
In the application, we have a feature where it will display all the years as tab. Each tab has amount(where the amount is the summarized) but at the same time it is have data. Scenario Just to give a background…
I have a request that I need to process multiple time during specific time frames, my implementation is working, but my user base is growing everyday and the CPU load of my database and the time taken to execute the…
10 million rows. MySQL server V. 5.7 Two indexes called "tagline" and "experience". This statement takes < 1 second: SELECT count(*) FROM pa WHERE MATCH(tagline) AGAINST('"developer"' IN BOOLEAN MODE); This statement also takes < 1 second: SELECT count(*) FROM pa…
How can I improve the following query's performance while the server is loaded? I've created a combo index and removed the index from the table because it's not picking it up, but is there another way to do it? ,…
I need help for performance this query SELECT * FROM transactions WHERE created_at BETWEEN '2022-08-25 01:03:21' AND '2022-12-13 01:03:21' AND ((transaction_reason IN ('ORIGINAL','REVERSAL_OF_ADJUSTMENT') AND type = 'DEPOSIT') OR (transaction_reason IN ('ADJUSTMENT','REVERSAL_OF_ORIGINAL') AND type = 'WITHDRAWAL') ) ORDER BY transaction_id ASC…
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…