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.

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

[Bild] 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…

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

Ich habe gerade Discourse installiert, aber die Seiten laden sehr langsam wegen einer langsamen externen Datenbank

Unterstützung Installation

pfaffman (Jay Pfaffman) 19. März 2025 um 22:30 3

Haben Sie eine Standardinstallation durchgeführt?

Thema		Antworten	Aufrufe
Are there any commands that will speed up the site? Support	19	2268	2. Dezember 2020
Best configurations for speeding up standalone discourse Self-hosting server-resources	26	4224	14. Februar 2024
My self host isn't as "fast" as other sites Self-hosting server-resources	11	328	14. Mai 2024
My discourse speed is very slow Self-hosting	24	4893	4. März 2021
Extreme Slow page loading (more than 1 minute to load) Support	9	793	19. September 2020

Ich habe gerade Discourse installiert, aber die Seiten laden sehr langsam wegen einer langsamen externen Datenbank

Verwandte Themen