What is the best way to implement resource counting?

Question

MySQL

Hello. Right now I have 2 columns for each resource.
--Max. quantity
-- current quantity
and common column for all
-- resource last recovery
time now I check how much has passed since the last recalculation and if more than 3 minutes have passed then I add n resources to the current quantity.

Interested in how you can optimize this business? Is there a better algorithm?

Answer 1

Implement this business on a timer. After all, you know exactly how much time from the current moment you need to increase the amount of resources. Start a timer that will raise the corresponding event. With t.z. performance - gain may be depending on the implementation of the timer. Well, the code will definitely become more beautiful.