Big use of Kanboard

Questions
1

Hello everyone !

Have you ever used kanboard with a lot of users?
I have deployed kanboard in my company since 1 year (with several homemade plugins).
Performances still perfect (for the moment), boards are loading very quickly.
Over time, I am afraid of having lack performances, especially with sql requests (I’m using MariaDB).

Do you have any experiences to share or advice?
Here are some statistics of my Kanboard usage :

Nb projects : 3040
Nb tasks : 70121
Nb tasks comments : 12998
Nb users : 5672

Version de l'application : 1.2.8
Version de PHP : 7.2.32
PHP SAPI : apache2handler
Version du système d'exploitation : Linux 3.10.0-957.12.2.el7.x86_64
Type de base de données : mysql
Version de la base de donnée : 5.5.60-MariaDB

Thank you !! :slight_smile:

1 Like
2

Bump! :smiley: calling out the pros out there!

3

holy moly, that’s a lot of users and tasks!

I just recently found out, that the user_has_unread_notifications- and user_has_notifications-tables took about 1/3 size-wise of our whole database. so keep an eye on that.

Other than that, you can try to find users and projects that you could move to separate kanboard instances to spread the load.

4

Hi !

Yeah I clean these tables regularly :smiley:
Performance still here with more users (and bigger custom plugin) :

Nb projects : 3758
Nb tasks : 128966
Nb tasks comments : 21592
Nb users : 6966