Flarum is slow in comparison to NodeBB

rob006

[deleted] Did you tried to cut Cloudflare and connect to server directly? Serving static HTML file should be instant, these 200ms looks like network overhead, and usually Cloudflare is first one to blame in such cases. 😃

[deleted]

rob006 Yes - results below

Error/Status Code: 200
Priority: HIGHEST
Protocol: HTTP/2
HTTP/2 Stream: 1, weight 256, depends on 0, EXCLUSIVE
Request ID: 0660047EAFDB49F3F237EBBBB947EDC6
Discovered: 0.008 s
Request Start: 0.123 s
DNS Lookup: 33 ms
Initial Connection: 33 ms
SSL Negotiation: 49 ms
Time to First Byte: 39 ms
Content Download: 1 ms
Bytes In (downloaded): 4 B
Uncompressed Size: 4 B
Bytes Out (uploaded): 1.6 KB

[deleted]

matteocontrini Yes, but not upwards of 600ms which I'm seeing at various points

matteocontrini

[deleted] yeah but if a static page with zero processing is 200ms, what is left to get to 400-500 is 200-300ms. That's the time PHP and MySQL take to generate the response and it seems ok to me.

[deleted]

matteocontrini Mmmmm.... But ask @rob006 about the TTFB on his site with WordPress, PHP, etc...

poVoq

[deleted] I thought perhaps it may be something in the database, although I see the same with hostrisk.com - this is a stable build from scratch (it does have a lot of extensions, but it's the same if these are all stripped back to just core). I've experienced this across three VPS providers too.

I also see some strangely slow behavior of Flarum sometimes and it is clearly related to database access. My not very expert guess looking at how the database is structured is that it has to make some really (unnecessarily) complex SQL queries some times.

[deleted]

poVoq I'd agree. I thought perhaps a missing index, but I haven't found any smoking gun yet.

SychO

[deleted] did you ever successfully install clockwork ? would love to see a screenshot of the database queries. (might wanna send that privately though).

matteocontrini

On my forum this is what PHP/MySQL take in processing on average (excluding network):

And this is the distribution of processing time:

Darkle

matteocontrini Which tool do you use to view these metrics?

matteocontrini

Darkle New Relic: https://newrelic.com/

[deleted]

SychO Yes, but didn't find it that useful. I can install again if need be and provide info via Discord ?

SychO

[deleted] pretty please

[deleted]

SychO Can you contact me on discord ? Phenomlab#4801

m4v3rick

[deleted]

Thanks for bringing up this thread. Just realized I could to some performance improvements but not yet sure what I can handle alone. 😅

[deleted]

m4v3rick let me know if you need help. Happy to assist.

« Previous Page