Every time I delete something from my db table I see that I have some overhead. Shall I add some sort of OPTIMIZE TABLE t1 to my DELETE query?
t1
"Every time I delete something from my db table I see that I have some overhead. Shall I add some sort of OPTIMIZE TABLE t1 to my DELETE query"
Depends how big the delete query is and how often it is run. http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
