Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] RDBMS reco...
 
Notifications
Clear all

[SOLVED] RDBMS recommandations

3 Posts
2 Users
0 Reactions
1,401 Views
Fathi Ben Nasr
(@fathibn)
Posts: 59
Active Member
Topic starter
 
[#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.


 
Posted : 18 Feb 2024 22H04
babynus
(@babynus)
Posts: 14966
Main Contributor 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


 
Posted : 19 Feb 2024 22H42
Fathi Ben Nasr
(@fathibn)
Posts: 59
Active Member
Topic starter
 

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


 
Posted : 20 Feb 2024 10H41
Share:

Scroll to Top