How to reset the order counter every day?

Question

PHP

Hello.
You need to reset the order counter every day.
There is a certain table where new orders go, active orders are also there, and completed orders are also there.
But the order number is already approaching 1,000,000, and it is already difficult to say it and the interface leaves
. What is the option to start the order number every day?
It's clear that you can add a column with an alternative order number to the table, but the question is how to keep the counter and reset it?

Answer 1

The simplest thing without much pain is to upgrade Redis ( poke ).
You can then drive any hot data and sessions into it.