Slow loading speed

oooo-ps

I've installed Flarum v2 on Debian VPS with default php-fpm configuration
Request to /api/discussions? takes 2599ms - is this okay?

I'm using SQLite, file sessions, but I'm looking for PHP options, maybe I forgot something.
Debug mode is disabled.

clarkwinkelmann

oooo-ps please share your php flarum info output so we can see which extensions and options are in use. Also, what's the approximate size of the forum, in number of discussions and users?

I don't have any experience with SQLite, and I believe it's also a new feature of Flarum 2.x. There probably isn't a lot of experience with it in the community yet. If that's an option, I'd suggest to compare the performance with MySQL on the same host to see whether it brings any improvement.

oooo-ps

php flarum info
Flarum core: 2.0.0-beta.3
PHP version: 8.2.29
SQLite version: 3.40.1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, Reflection, SPL, session, standard, sodium, PDO, xml, apcu, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, intl, exif, pdo_sqlite, Phar, posix, readline, shmop, SimpleXML, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+----------------------+---------+--------+
| Flarum Extensions    |         |        |
+----------------------+---------+--------+
| ID                   | Version | Commit |
+----------------------+---------+--------+
| flarum-tags          | 2.x-dev |        |
| flarum-suspend       | 2.x-dev |        |
| flarum-subscriptions | 2.x-dev |        |
| flarum-sticky        | 2.x-dev |        |
| flarum-mentions      | 2.x-dev |        |
| flarum-markdown      | 2.x-dev |        |
| flarum-lock          | 2.x-dev |        |
| flarum-likes         | 2.x-dev |        |
| flarum-lang-english  | 2.x-dev |        |
| flarum-flags         | 2.x-dev |        |
+----------------------+---------+--------+
Base URL: 
Installation path: /var/www/flarum
Queue driver: sync
Session driver: file
Mail driver: mail
Debug mode: off

luceos

oooo-ps it really isn't enough to go on honestly. SQLite might have a dramatic effect on larger databases and slow filesystems, but we haven't done any comparisons with it yet as SQLite is deemed for development purposes only. Can you share the server specs and do a test with mysql?

KBExit

I don't know about 2.0 particularly. But I have fast load times thanks to:

Redis Cache
Cloudflare Proxy
Local Cache
MySQL