I got a little problem and I hope that you, experienced designers, might help me out with it. I have a dynamic table with ID lets say TINYINT. Content of this database is changed offenly (INSERT / DELETE) and I would like to have ability to INSERT very fast. So normally I use auto_increment to make sure that every next INSERT will place item with next ID. It's working OK, but... but if i INSERT 5 rows and DELETE 5 rows, next time I use INSERT I get id=5. So as you see after around 255 INSERTS and DELETES I cant add anything new even if mine table is empty (or half-empty etc.). My question is: how you prevent this problems? Its not an option to use very large ID's in this case
Start Free Trial
