Forum

[SOLVED] RDBMS reco...
 
Notifications
Retirer tout

[SOLVED] RDBMS recommandations

3 Posts
2 Utilisateurs
0 Reactions
1,377 Vu
Fathi Ben Nasr
(@fathibn)
Posts: 59
Estimable Member
Début du sujet
 
[#9326]

Hi,
Is there any recommendations to which rdms to use based on number of simultaneous users and projects ?
10 users -> MariaDB ?
100 users -> PostgreSQL ?

Are there any differences ? It seems ProjeQtor is mainly tested and developed with MariaDB as sometimes i face some trouble updating my instance which uses PostgreSQL while "MariaDB instances" seem not facing these troubles.
With which rdms ProjeQtor is faster, given the same hardware for the rdms server ?
TIA.
Fathi B.N.


 
Posté : 18/02/2024 10:04 pm
(@babynus)
Posts: 14952
Membre Admin
 

There will be not difference between PostgreSql and MariaDB or MySql depending on number of users.
The difference will be mostly on volumetrics (number of lines in talbes).
Postgres will be a bit better for very large tables (over million lines)

What is sure is that most users have MySql or MariaDB (it's the same for ProjeQTOr) so some specific errors on PosgreSql may remain when MariaDb / Mysql have no error


 
Posté : 19/02/2024 10:42 pm
Fathi Ben Nasr
(@fathibn)
Posts: 59
Estimable Member
Début du sujet
 

So, i will stick with PostgreSQL and be happy to be one of the PostgreSQL testers for ProjeQtOr.


 
Posté : 20/02/2024 10:41 am
Share:
Retour en haut