Homepage take up 2-4 sec to respond Started GET "/" for 219.144.218.209 at 2025-03-17 18:22:55 +0000 Processing by ListController#latest as HTML Rendered layout layouts/application.html.erb (Duration: 1932.6ms | GC: 10.6ms) Completed 200 OK in 2521ms (Views: 1933.4ms | ActiveRecord: 0.0ms (0 que…

Did you do a standard install ?

Yes, i did. And i found issue yesterday. I used a remote database, The layout component of discourse fetch 60+sqls, every sql need ±30ms to transfer，so the first render cause 2-4 sec. The issue go away when I changed to local database.

TrevorWoods: Check if your server meets Discourse’s recommended specs Yes, it does: [image] 佳闻_刘: 2 CPU cores and 8GB of RAM

I’m having a similar problem. I think the docker might be doing some kind of magic indexing on internal databases only, which isn’t great as that severely limits how we can scale.

[image] Eviepayne: I think the docker might be doing some kind of magic indexing on internal databases only Hmmm … that doesn’t sound right to me. The same migrations should be being applied regardless of where the database is … and that includes the addition of indexes. It would be good to…

I have this plan I did a while ago for a long running query: Plan created on March 28th 2025, 4:09 pm explain.dalibo.com Visualizing and understanding your PostgreSQL execution plans made easy. This plan WAS a database that was locally hosted, disk IO was t…

[image] 佳闻_刘: every sql need ±30ms to transfer This is comparatively a huge amount of time. There’s something very wrong with your SQL setup. How remote is the database? 99th percentile of total SQL time for logged-in requests on meta (hosted in AWS) is ~54ms and on our metal hosting for a …

Je viens d'installer Discourse, mais les pages se chargent très lentement à cause d'une base de données externe lente

Assistance produit Installation

pfaffman (Jay Pfaffman) Mars 19, 2025, 10:30 3

Avez-vous effectué une installation standard ?

Sujet		Réponses	Vues
Are there any commands that will speed up the site? Product Support	19	2609	Décembre 2, 2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	25	4687	Février 14, 2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	540	Mai 14, 2024
My discourse speed is very slow Self-hosting	24	5434	Mars 4, 2021
Extreme Slow page loading (more than 1 minute to load) Product Support	9	902	Septembre 19, 2020

Je viens d'installer Discourse, mais les pages se chargent très lentement à cause d'une base de données externe lente

Sujets connexes