Davis Sorry, I wasn't very clear in my post. I didn't really specify when I was talking about the Flarum frontend and backend.
The idea that I'm currently entertaining is keeping the phpBB database as it is and writing an API bridge for the Flarum frontend. Depending on how Flarum is organised I probably won't be using much of the Flarum backend at this point.
The Flarum frontend would be the main interface of our forum, this would talk to the API bridge which updates the phpBB database. Because we won't change the database the old interface will remain functional, including all the extra moderation tools.
When all that is up and running we can extend the Flarum frontend with features that we port from our old forum. As you said; a big part of Flarum is in the frontend, so if we port something to the frontend it will be fairly easy to make that feature available in a 100% Flarum setup by writing a fairly small piece of Flarum backend. That would be a win-win. Especially if we would sponsor you to write the frontend (and maybe also the backend) part(s).
Regarding performance; I'm certainly not assuming that Flarum is slow and has performance issues because it's in beta. I haven't done any real testing yet, but according to the issuetracker and roadmap the database doesn't have any indices yet except for the primary keys. It's close to impossible to get decent performance out of that on the backend side of things. That's probably reasonably easy to solve, but it's doesn't seem to be tested/implemented yet. The frontend is rather responsive indeed. I would like < 100ms for every PHP call, but the current state already seems to be very acceptable, also because the interface is decoupled from the backend. And the frontend certainly seems to be snappy. Haven't tested older mobile devices yet, but it seems to be faster than most 'webapps' that I've seen. Kudos on that!
isti37 How would mysql-live-select fit into an API bridge? Live select seems to be focussed on sending streaming data like statistics or newsfeeds. Flarum would need random access to the whole database.
But very curious as to your plans, you seem to have experience with larger phpBB installs?