I'm trying to learn Normalization concept using object. I'm having doubt in that Normal Array of Object: const state = { users: [ { id: 1, name: "Alice", posts: [{ id: 101, title: 'Post 1', comments: [{ id: 202, text:…
I have a MYSQL database with a table 'product', about 500 000 rows, with a column 'oem' (varchar 255, utf8_unicode_ci). I have another table 'oem' with a column 'oem' too (varchar 255, utf8_unicode_ci), about 150 000 rows. I need to…
I'm currently exploring strategies to optimize data storage and retrieval for an enterprise-level application that demands high scalability and performance. In my quest to enhance efficiency, I've considered leveraging React's capabilities such as memoization, PureComponent, and React.memo. One approach I'm…
I have a table named "Applications" where I keep track of the applications made by my candidates to vacancies. Now, I need to write a statistical query for HRs, and when an HR logs in, I should bring the candidates…
I have the following query: select count(*) as aggregate from users where date(created_at) < '2024-04-01'; It returns 2337355 which is a correct number. But it takes over 1.5 secs to be executed. Any idea how can I make it more…
I'm working on solving this problem on leetcode (https://leetcode.com/problems/linked-list-cycle/description/) and my original solution exceeded the time limit (Example A). I was eventually able to make the solution fast enough by changing two lines of code and the solution was accepted…
we have in our system a query that supposed to filter reports based on some factors the query is indexed , and when use explain it shows like it uses the indexes but the row numbers are the same amount…
Here is a snapshot of my code. exports.getTestCases = async (bucketName, startTimeStamp, endTimeStamp) => { let results = []; let startTime = parseInt(startTimeStamp); let endTime = parseInt(endTimeStamp); const maxDataLimit = 1500; const maxYearsBack = 10; const oneYearInMilliseconds = 31536000000; let…
I've been investigating an issue with one of our application queries running very slowly and it seems to be related to a particular view we're using. Here is the full query with the selected columns omitted (there are 408 columns…
For many years, our website, which was built using Typo3, has been experiencing slow performance for the past week. When we try to visit our site, the loading times are quite slow, sometimes taking 3-4 seconds, while other times it…