I am currently working on a project that has 2 very large sql tables Users and UserDocuments having around million and 2-3 millions records respectively. I have a query that will return the count of all the documents that each…
I'm working with a list of notes in React Native, and I was using a bad-performant method to select/deselect the notes when I'm "edit mode". Everytime I selected a note, the application had to re-render the entire list everytime. If…
⛰️ Hi comunity, I'm using a normal MySQL query to join 2 tables. My query in a simpler way looks like these (for these example i just put *, otherwise i have targeted elements) SELECT table1.*, table2.* FROM table1 INNER…
I have a users table with bio field and "n:n" relationship with itself via the followers table so each user U can follow many other users. My user search query is super slow. All queries get the first 20 search…
I have a table with close to a billion records, and need to query it with HAVING. It's very slow (about 15 minutes on decent hardware). How to speed it up? SELECT ((mean - 3.0E-4)/(stddev/sqrt(N))) as t, ttest.strategyid, mean, stddev,…
I have a huge mysqldump file (~700GB) that I want to restore on a different server. For the first GBs, the import is quite fast with some MB/s, but after some GB of data, the speed drops to something between…
I've recently switched from V11 to V14 of PostgreSQL, and some of my CTE queries, that used to take a few milliseconds, now takes a few seconds. The minimum query to reproduce this issue is the following : WITH MyTable…
Using MySQL 5.7, I have a table of urls containing url_title, url_description, url_keywords Sometimes I just need to look in url_title, but sometimes look for something in all columns. Is it better to just create one index containing all 3…
I have run up against an interesting performance issue when comparing the exact same .net code in Windows and macOS. I don't understand why there's such a significant performance difference, and I'm not sure of the best way to proceed.…
After enabling hermes engine in podfile throws error while building app "Undefined symbols for architecture x86_64: "vtable for facebook::react::HermesExecutorFactory" Hermes version : 0.9.0 RN : 0.66.1 podfile platform :ios, '11.0' target 'OneSignalNotificationServiceExtension' do pod 'react-native-onesignal', :path => '../node_modules/react-native-onesignal' end target…