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…
I have the following query: SELECT DISTINCT FIRST_VALUE(business_id) OVER (PARTITION BY b.sub_category_id ORDER BY AVG(stars) desc, COUNT(*) DESC) business_id, sub_category_id FROM purchase_experience pe JOIN businesses b ON b.id = pe.business_id AND b.status = 'active' AND b.sub_category_id IN (1010 ,1007 ,1034…
I quickly wrote this code to test when all sides and diagonals of a cuboid a,b,c,d,e and f are all integers. It seems to work just fine but it takes way too much time for higher and higher values to…
I have some SVG in a list, there are about 100 nodes. They looks like: <li> <div class="icon"><svg><path .... </svg></li></div> </li> ... another 1000 <li> Should I turn them into CSS? <li> <div class="icon"></li></div> </li> .icon { width:20px; height:20px; background-image:…
I have a huge dataset on two tables (users, pos_transactions), and I need to execute a join on them. I wrote the query both with join and subquery approches. Both looks Non-optimal: explain SELECT pt.card_number FROM pos_transactions pt where user_id…
I have a simple subquery in MySQL which produces a set of codes, something like 'LPR','LFR','LFL' (more codes can be returned). Using this in my main query slows it right down, like it can take a minute or 2 to…
I'm encountering a PHP execution time error while inserting approximately 250k records into a MySQL database using Laravel Eloquent. I'm aiming to achieve this without increasing the overall execution time, considering the following constraints: Frontend: Angular Multi-tenancy: Implemented using https://tenancyforlaravel.com/…