I have a NextJs v12.3.0 app that use sx in MUI as styling to many of my components. many of my pages are render as SSR. now i want to know somethings. Does MUI render sx styles as inline css?…
I have 2 tables in Postgres, one is of about 200M records, and the other a few hundreds. I want to get 10 values from the small table and find the corresponding values in the long table. both are indexed.…
I'm trying to organize my partner management using Google Sheets. I have a main spreadsheet where columns F-I are dynamic, meaning I want data from these columns to be transferred to columns A-D in the partner spreadsheet. However, this should…
Is there a better way in Powershell to handle multiple levels of returned values than nested foreach loops? I need to get a list of each of our Azure Virtual Desktop session hosts for further processing. This requires me to…
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…