Lev Shkatov

Actual free RAM is ~3GB. SQL `explain analyze` produces such results (I just removed join categories from query): 1. Number of products: 100 ``` Limit (cost=65.00..65.00 rows=1 width=40) (actual time=0.252..0.253...

After several attempts, I managed to make it work. Even the entire route `/admin/products` is functioning. It is quite slow, but it works. Therefore, if we cannot influence TypeORM's querying...

I don't know about indexes now, it was just a suggestion. This route includes many queries, and they work perfectly except first distinct one. However, it also works after multiple...

Firstly, I tried the simple route from the admin dashboard, limiting it to 15 with default fields and expanding. It broke after a 1-minute timeout, and I realized that the...

I just logged the database queries that produce an admin request for the products list (`/admin/products?offset=0&limit=15...etc`). I realized that it generates approximately 120 queries to the database and around 90...

Thanks for reply! It's also strange for me even because I have only one currency and one money_amount per variant. So, I expect simple price calculation but not such a...

Could you tell, how many products and variants do you have for this screenshot? For 1000 products and 10000 variants I also have excellent performance result

What route are you fetching: admin or store? And what query parameters, apart from offset and limit, are you using? I will try the same tomorrow on the database with...

I optimized the structure of my data. Now I have 270.000 products, 1 mln variants, 1 mln options, and 1 mln money_amounts. I tried to fetch products from the admin...