I'm trying to find out, why a simple aggregate query performs really slow on Postgres 15 from my point of view. I have a growing data table with 10 mio records of sensor data CREATE TABLE public.ts_number ( id int4…
Frontend: Reactjs Backend: Nodejs + Express Database: Mysql Workbench Hosting: Linode Now I have an event that is scheduled to run every 2 seconds to update the status column. However, I am worried that the event might affect the performance…
I need help for performance this query SELECT * FROM transactions WHERE created_at BETWEEN '2022-08-25 01:03:21' AND '2022-12-13 01:03:21' AND ((transaction_reason IN ('ORIGINAL','REVERSAL_OF_ADJUSTMENT') AND type = 'DEPOSIT') OR (transaction_reason IN ('ADJUSTMENT','REVERSAL_OF_ORIGINAL') AND type = 'WITHDRAWAL') ) ORDER BY transaction_id ASC…
I am designing a basic ERP (nodejs/express/postgresql-vue3/quasar), in which several businesses of different clients will be managed, some of these clients have several businesses with some branches, I should implement a server/database instance per customer or should I look to…
After switching a personnal solution from .NET 6 to .NET 7, time to read large amount of data go from 18s to 4min 30s (approximately). Before starting to develop it, I have a test function allowing me to have the…
we have a performance problem in our calendar widget. We want to display 3 Years in a scroll view. Each day should be displayed and some days should be marked. The problem is, that the rendering time of this widget…
I'm trying to get summary data from a table (dd=devicedata) that gets data every 10 minutes. I want to get the data for one day (24 hours), i.e. get the summary of 144 rows into one. devicesData is indexed on…
at my company, my teammate said that"in Flutter, static usage is very harmful for memory. You shouldn't use static variables too much." After that, I have searched the internet, but I couldn't find satisfaction answer. So, I just wonder that…
I'm working in a Django project and it has a postgreSQL db. I'm calling multiple times the model to filter the results: latest = Product.objects.all().order_by('-update_date')[:4] best_rate = Product.objects.all().order_by('rating')[:2] expensive = Product.objects.all().order_by('-price')[:3] But I wonder if it's better for performance and…
We have a nodejs monorepo project with >179 packages where each package may have >30 files. It also contains proxy with routing and several forked processes (as usual). So, when we packed all of this stuff into Docker image and…