I am creating a module where every user often gets a record into a table for 10 to 300 seconds.
When the time expires a record gets deleted. The case is: there will be a lot of users and records will change really often – how this will affect application's performance for this table, because records will change really often and I am wondering if mysql is fine with that? Like indexes would come and go, data changes like 200 times/seconds for this particular table. Maybe I am choosing a bad solution for this kind of job. Any suggestions ?