I am trying to run a transaction report but it is taking more than 40sec then timeout by the server. Hope I can get some help to get it optimised. select test_txn.abcid, txndate, txndate2 from test_txn inner join test_abc on…
i have a query in postgres which is taking 1 min and a few seconds to execute, found out that it's due to the order by clause. my understanding is that order by clause is one of the last to…
I have a Sql database with +2 million rows and growing fast. There aren't many columns, only code, price, date and stationID. The aim is to get the latest price by code and stationID. The query works well, but takes…
com_cards_charge : com_cards_charge table(DB) com_debt : com_debt table(DB) some of result: Result1 Result2 SELECT * FROM com_cards_charge, com_debt where com_debt.com_debt_cards_charge_id = com_cards_charge.com_cards_charge_id AND debt_Creditor_type in (0, 15) AND com_cards_charge_deleted = '0' GROUP BY com_cards_charge.com_cards_charge_id order by com_cards_charge_id DESC This query…
I have a slow delete query. As suggested here when I add an index I get much better results. Beside this scenario I don't need this index, so what I did is: Added the index. Deleted the rows. Dropped the…
I'm using MySQL and have a table with name Music that has tracks information like title,duration and ... This table also has "total_hit" column that it's value will be updated frequently by each track played(+1) : id title duration ...…
We have an expensive query that needs to extract daily values from a table storing metrics for objects over timeranges. We have isolated the expensive part of the query and extracted the following minimal example. Some details on the tables…
basically, I'm trying to optimize this query we have more than 100K blogs and I need to make it faster now it takes Load time (07.46 s). <?php if ( get_query_var( 'paged' ) ) { $paged = get_query_var( 'paged' );…
I have 2 big tables in my database (wp_frm_items with about 3 million rows and wp_frm_item_metas with about 35 million rows). I'm using the Query Monitor WordPress plugin and noticed that queries using joins and making counts are slow. Some…
Here is the scenario: we are using Azure Synapse analytics with 100 DTU, we have several tables. All tables are round robin distributed and clustered columnstore because data is loaded once in a day and we want it to be…