Feature Requests
Share ideas, discuss and vote on requests from other users in community
 
This object is in archive! 

Improve Database Structure

nobody shared this idea 6 years ago
Under Consideration

I think it would be useful if WHMCS had a better database

structure, for example, nearly every field is a text field regardless of what

content is inside.

Comments (4)

photo
1

agreed, also alot of fields are comma seperated values, which means you need to use CONCAT alot which is pretty bad.

photo
1

Yes, The database structure is very basic and it is not in normal form. It must be a least in 3NF or BCNF.

https://en.wikipedia.org/wiki/Third_normal_form

https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form

photo
1

Another issue is that each session needs to write somewhere in database. We saw the issue in setting our HA setup worldwide, when using remote mysql, we were seeing huge loading speed issues due to whmcs... (test with a wordpress demo website showed no issue in simple read of DB)

photo
1

Hi Johann,

Up to now PHP session data was always stored in the PHP file session storage location for your server. With 7.7 you can choose to natively store database session data in a database: https://docs.whmcs.com/Sessions

I hope you find this new feature beneficial!