I have one table which has 13.236.327 rows and the size of the table is approx 500MB, While I perform simple insert query it take more time. In New Relic also it present as slow query. I have only 3 columns in the table and there is no INDEX in that table. Check below image for the table structure.
I am thinking to drop the "on update CURRENT_TIMESTAMP
" from last column and while create the query then get the current datetime and then insert, will it speed up the insert?