Make a table, the data table 1800 per second updates a fixed size, when update to 30 minutes 1 seconds, the first record to be deleted, this update the database, how to do?

CodePudding user response:

Want to complicated,

Your request is actually "insert a at the same time, delete 30 minutes before"

CodePudding user response:

It's not suitable for you use SQL, no more suitable, and even get a redis