Here is the query, here al.activated_date column is having timestamp. I want to group by application.id, application_logs.activated date. When i remove DATE(al.activated_date), query excution time is 1.2sec. But when i use it, exceeds 15sec.. SELECT a.id, a.description, DATE(al.activated_date) as activated_date,…
I have a project with Laravel v6 (mix) and vueJs v2 It has LCP error My website LCP is a hero image that I used it like this <picture> <source media="(min-width: 1536px)" :srcset="getAssetPath('/v2/assets/images/home-new.webp')" type="image/webp"> <source media="(min-width: 1280px)" :srcset="getAssetPath('/v2/assets/images/home-bg-1535.webp')" type="image/webp"> <source…
There is an index on requestedAtTimestamp_-1 but the query regularly takes over 5s and Mongo Atlas is shouting at us saying The ratio of documents scanned to returned exceeded 1000.0. Are there additional indexes that could help to speed up…
I have a huge table for load to Cloud (BigQuery). Table have very simple structure: CREATE TABLE `my_huge_table` ( `user_id` int(10) NOT NULL, `value_id` int(11) NOT NULL, `some_value` tinyint(2) unsigned NOT NULL DEFAULT '1', `created_at` datetime DEFAULT NULL, `updated_at` datetime…
I have a reactive bool. Now if that is true I show a widget , but in case that is false then I don't need to show anything at all in that place. As of now I am adding a…
I'm trying to save an HTML div containing both text and images as an image. I've used canvas-based methods like html2canvas, but it takes a lot of time to generate the image, especially for larger or more complex content. Is…
I'm working on a React Native project with TypeScript, and I'm trying to import an image like this: Cannot find module '@/assets/image.png' or its corresponding type declarations.ts I've already checked that the image exists at the specified path. How do…
I have a SQL query that fetches one row (LIMIT 1) for a specific client code from the TABLEA based on several conditions. Here's the query: SELECT `TABLEA`.`client_code` FROM `TABLEA` WHERE ( `TABLEA`.`accounting_date` = 202408 AND ( `TABLEA`.`FLAG1` = ''…
This query is taking more than 90 seconds UPDATE `tableA` SET `bill_no` = NULL WHERE `tableA`.`payment_no` = 'S00005303'; how to find the cause of slowness I checked show processlist; and there are no other queries running at the same time.
I have a SQL query when joining several large tables. My database consists of millions of rows across the users, orders and transactions table. Here is the query SELECT u.name, COUNT(o.id) AS order_count FROM users u JOIN orders o ON…