I need to select all records for the current day in CST, however the timestamp fields in the table are all in GMT/UTC. The server's timezone is GMT. Getting all records for the current day in GMT is very fast…
Trying to debug a slow query: SELECT IFNULL(SUM(bt.transactionQuantity * bpd.unitPrice), 0) FROM batchTransaction bt LEFT JOIN batch b ON b.id = bt.batchId LEFT JOIN batchPricingDetails bpd ON bpd.id = b.batchPricingDetailsId WHERE (bt.productId, bt.dateCreated) IN ( SELECT productId, MAX(dateCreated) FROM batchTransaction…
I am seeing lot of this wait event in my AWS Aurora MySQL (8.0.mysql_aurora.3.04.0) and the documentation says "this event indicate an increase in workload activity. Increased activity means increased I/O", which causes spike in CPU usage. Note, the underlying…
I'm currently developing a SOAP service with several operations. Requests and responses are saved in a table called "message". Each Request and each Response is its own entry in the table and each Request/Response pair has a corresponding correlation_id. I…
I have a query like this: SELECT DISTINCTROW customers.id, customers.customer_name FROM customers INNER JOIN rentals ON customers.id = rentals.id_customer INNER JOIN rentals_billing ON rentals.id = rentals_billing.id_rental INNER JOIN vehicles ON vehicles.id = rentals.id_vehicle WHERE (rentals_billing.customer_id_facsimile IS NULL AND rentals_billing.rental_payable =…
I have the following query to display the performance of a machine in 8-hour segments (although it can change to 1 hour, 1 week, 1 month, etc.). My table has 2 million records, and the query takes 10 seconds to…
I have a PHP script that use 4 separate query to read the last 25 rows from one single mysql table (so a total of 100 rows). Example: SELECT * FROM table WHERE datetime <= 'xxx' AND name = 'john'…
I am executing the below query in PostgreSQL but it is taking more time than oracle. In PostgreSQL it is taking 1.5 second and in oracle it is taking nearly 0.009 second. select ex1.currency_id, ex1.underly_currency_id, ex1.type_id, ex1.third_id, ex1.market_third_id, ex1.exch_d, ex1.daily_dflt_f,…
I am facing a problem with a SQL query, which takes around 500ms when queried using RAW SQL (retrieve all data without limit). However, using the same query in laravel(tried Eloquent, DB builder and RAW) it takes around 15 seconds…
I'm working with a Delta table in Databricks that is partitioned by a Year column, and I have a timestamp column in the table. I want to optimize my queries to fetch data within a specific timestamp range (e.g., between…