A table (phototag) consists of two foreign key columns (photoid, tagid). I want to get the most related photos based on their tags. There are 4 million photos with 5-10 tags. For example, the photoid 10009 has 6 tags. I…
Consider we have A,B,C,D,E,F,G,H columns in my table and if I make composite indexing on column ABCDE because these column are coming in where clause and then I want composite indexing on ABCEF then I create new composite indexing on…
I have a ledger-like table in a postgresql DB that tracks events for film comparisons on a site where users can add/remove film comparisons. Each event is recorded as a timestamped row in the event database. Rows are never removed:…
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…