Is it wise to delete mysql rows frequently?
Posted: Fri Nov 30, 2012 1:11 am
Hi there,
I have user login system in my website. For implementing secure login system and also for browser specific login system, it is need to delete mysql table rows frequently as users logout.
Also a new row will be created frequently while a user logs in to my website.
I can't maintain row for each user permanently because a user can login from 4/5 browsers and for each browser it needs to create one row. So If I have 500 or more users, in that case for faster searching, I don't want to keep rows which has no data about user login (e.g user logs out from a browser, so I don't need to keep information of that browser any more).
My question is if rows delete and create frequently, will it affect of that mysql tables/database?
And in that case, should I have to repair that table periodically?
Any help will be appreciated.
Best Regards
I have user login system in my website. For implementing secure login system and also for browser specific login system, it is need to delete mysql table rows frequently as users logout.
Also a new row will be created frequently while a user logs in to my website.
I can't maintain row for each user permanently because a user can login from 4/5 browsers and for each browser it needs to create one row. So If I have 500 or more users, in that case for faster searching, I don't want to keep rows which has no data about user login (e.g user logs out from a browser, so I don't need to keep information of that browser any more).
My question is if rows delete and create frequently, will it affect of that mysql tables/database?
And in that case, should I have to repair that table periodically?
Any help will be appreciated.
Best Regards