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.
agreed, also alot of fields are comma seperated values, which means you need to use CONCAT alot which is pretty bad.
Yes, The database structure is very basic and it is not in normal form. It must be a least in 3NF or BCNF.
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)
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!
Comments have been locked on this page!