How to index table to improve performance
1. alter table wp_tender_user_cron add unique index(tenderID, userID); sebelum nak add unique pair index ni, kena make sure takde duplicate.. select tenderID, count(*) as bil from wp_tender_user_cron group by tenderID,userID having bil > 1 order by bil desc; delete all duplicate row jika ada. 2. Enjoy Optimized DB!