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…

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.

[afbeelding] TrevorWoods: Check if your server meets Discourse’s recommended specs Yes, it does: [afbeelding] 佳闻_刘: 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.

[afbeelding] 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 go…

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…

[afbeelding] 佳闻_刘: 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 f…

Ik heb zojuist Discourse geïnstalleerd, maar de pagina's laden erg langzaam door een trage externe database

Ondersteuning Installatie

pfaffman (Jay Pfaffman) 19 maart 2025 om 22:30 3

Did you do a standard install?

Topic		Antwoorden	Weergaven
Are there any commands that will speed up the site? Support	19	2269	2 december 2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	26	4238	14 februari 2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	331	14 mei 2024
My discourse speed is very slow Self-hosting	24	4894	4 maart 2021
Extreme Slow page loading (more than 1 minute to load) Support	9	797	19 september 2020

Ik heb zojuist Discourse geïnstalleerd, maar de pagina's laden erg langzaam door een trage externe database

Gerelateerde topics