I'm searching for the faster way (performance-wise) to create the
following structure with mysql:
I've a table where I take an history of things that happen in a
This table contains just some integer and a creation timestamp in UNIX
Every time there is a new event to add to the history I just INSERT it
The problem is that I want this history to contain at MAX 10000
Older elements should be removed in some way.
What's the faster way to take the history limited in length?
This is my best try so far.