Unfortunately we cannot deal with the api.php high load when Decay is enabled. (I Using php-fpm + Apache + Well optimalized PerconaDB mysql - On AMD EPYC CPU / but tried with a recent Xeon Gold CPU too). We bought a dedicated server for 70 euro with nvme ssd, new recent cpu and the api.php peformance is very dissapointing. NOTE: I using a similar server configuration for a webshop, contains 30K products and have 20K users...
I would like to ask, how to make a valid simple adjustment to an user trough the sql. As i see, there's a table: "eqdkp23_adjusments", which have a "adjustment_group_key" - Where does this key comes? If i make a single adjustment, then this key is also generated individually. But if i just insert a new adjustment, that will not displayed on the page. How to make this work?
If i don't use any decay, then it's working fine and relative fast. I would like to make a script which is run as a cronjob, and make the adjustments trough an SQL insert. Gets the users current points, then make a single adjustment with minus 10% and run once a week.
Thank you very much!