I am really struggling with producing some code create 'level1 question' & 'level2 question' columns. The logic to populate the columns is: 'L1' when level = 1 & type = group then question 'L2' when level = 2 & type…
I recently wrote this function for deep cloning an object in javascript, but with the given time complexity it would be extremely slow, any tips on making it more effecient? function deepClone(obj){ let clone = {}; for (let k in…
I tried to replace all the JSON lottie files in my Android project to dotLottie file format. In the project a single JSON that was around 200kb was reduced down to 20kb. So replacing around 30 such files should have…
I have a big object like below containing 1mil props. { "Name1":{"some":"object"}, "Name2":{"some":"object"}, "Name1000000":{"some":"object"} } I want to split this object into N parts so I wrote the following code var bigObject = { "Name1": { "some": "object" }, "Name2":…
I have a table in my database with many (10+) int4 columns, and I am also developing an application server which updates these values. My current approach requires multiple round trips, because I do something like this, each as a…
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 have a couple of tables in PostgreSQL 14.6, with indexes as stated here: # d uprn Table "public.uprn" Column | Type | Collation | Nullable | Default -----------+----------------------+-----------+----------+--------- uprn | text | | | postcode | text | |…
I have an image URL, and I'm providing it to the image src attribute on a modal component. When the modal opens, there is a black card for a few seconds till the image shown. How can I make it…
I have a huge table with over 10M rows. I need to update the following rows: select * from customers_card_psp where status="not_added" and psp_id = 2 order by id limit 50000 Since I have a composite index on customers_card_psp(psp_id, status),…
I have a Wordpress website that has a photo slider on the homepage. Also, my blog page loads extremely slow both on desktop and mobile. Can someone please help me with this? https://clfapartments.com https://clfapartments.com/blog