Magento2 loading speed is very slow
I have got an issue with Magento project loading speed. I have built Magento2 project and worked on it and hosted it in CONTABO server. The server RAM is 16GB. I think it's enough for hosting. But when I am…
Postgresql – enum vs text data type in posgresql performance
I have a column in postgresql that is a text data type. But it really holds always 4 kind of values, these are: EOS,EOS in 6 months,EOS in 12 months, EOS in 24 months I always perform the same kind…
how to improve strcmp mysql performance comparing similar strings
I hope this is not a duped question. I've looking around and can't find any question like mine, but... I have a table containing people's data, and we know there are duplicates. The table contains more than 30k entries and…
Redis cache optimization in .NET 8
The performance is not up to mark when serializing/deserializing a big JSON file (~3 MB). We are using Microsoft JSON serialization. Is there any other serialization that would help to optimize the cache and provide good serialization/deserialization performance?
Javascript – Is there a better way of writing this If statement?
I was working on a JavaScript program, and needed an if statement to assign a value to a variable when a is larger than b. if (a > b) { c = 11; } Is there a better way of…
Php versions – Slow loading of large php files on PHP 8.2 gloogle cloud engine
We're using cache files that consist of a combination of simple PHP code and HTML. These cache files are stored with a PHP filename. Some files exceed 400 KB, and I've noticed that Google App Engine, specifically with PHP 8.2…
Javascript Engine Optimization
If I have the following code in Javascript: import getTranslation from "some-library"; import getUserSettings from "some-other-library"; const getTranslatedLabel = () => { const translatedLabel = getTranslation("cheeseburger"); const { enableTranslatedLabels } = getUserSettings(); if (enableTranslatedLabels) { return translatedLabel; } else {…
GitHub Action `gha` Docker cache much slower than recreating the image
I set a GitHub actions to build and run tests on my Docker image. While building the Docker image, a rather heavy file (6Gb model from Huggingface) is being downloaded. (As a side note - I can possibly bring it…
Postgresql – Why does Postgres optimizer switch to nested loop for join?
Using Postgres and Postgis I was experiencing a very slow spatial join using st_equals. Out of curiosity, I tried using = instead, and the join was much faster. Using EXPLAIN, I noticed that the st_equals join uses a nested loop,…
PostgreSQL better query performance
I have customers and visits table, and I would like to know which of these two queries has the better performance: (I have indexes defined for those columns) Query 1 SELECT customers.id as id, COALESCE(v.count, 0) as visits FROM customers…