database size is big

sanwhere

my phpbb forum has a 1.1 gb database size and almost 100k users, and i want to move it to flarum or discourse or nodebb.

can you guys please give me advice about performance, which one you prefer?

clarkwinkelmann

Flarum still being beta, you can expect performance to change a lot from release to release until stable.

Also what extension do you plan to use ? Poorly written third-party extensions could totally ruin your experience with bad database or code.

Strictly speaking about performances in core, Flarum caches the count of most things so it doesn't require joins and count on the fly, which is probably a nice performance boost. It all falls back on your database engine then.

Hope this helps ?

sanwhere

thanks for your quick response.
i dont wanna use any extensions, first i just wanna move my phpbb forum to flarum or the other systems.

BartVB

A while ago I did a quick test conversion of 1MM posts which has resulted in a Flarum DB of 1.1GB in size.

Performance is not dramatic but the DB schema that Flarum uses hasn't really been optimised yet. This is probably fairly easily fixed by adding some indices where appropriate. Haven't looked into this yet, first need to find a way to add some kind of debug bar or query logging to the pages. I'm used to Symfony apps, Flarum works quite a bit differently, especially with the JS frontend app.

In my case server times for most pages are between 600 and 1000ms without any optimisation. Not nearly acceptable for our use, but it seems to be on par with the performance of flarum.org at this time.

But track this Github issue:
flarum/core127

sanwhere

Actually, after cleaning of phpbb database, the new size became 380mb. This is better size to handle it i guess. i hope its gonna be fine. We ll see.