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!

Comments

Post a Comment

Popular posts from this blog

ELK - Elastic | Logstash | Kibana

Image
http://bit.ly/elkubuntu - Hisham ElasticSearch cluster, Logstash & Kibana (Elastic Stack) installation with x-pack on Ubuntu 18.04 Revision History Date Details Version Added x-pack installation method into the document 1.4 Added method to upload csv  to logstash Added way to create index pattern in kibana, and view them 1.3 Added performance improvement segment Added more example on configuration sample Added simple architectural diagram Added fiebeat installation and configuration 1.2 Formatting improvements Added Revision History Added Reference Added Table Of Content 1.1 30/5/2018 First revision Added installation procedure 1.0 Prepared by: Hisham Mohd Aderis ( hisham@songketmail.org ) Table of Content  Revision History 1 Table of Content 2 Simple Architectural Diagram 4 Java installation 5 Oracle Java 5 Open JDK 5 Elasticsearch 6 Installation 6 Conf...
Read more

Akibat dari tiada jadual selenggara

Image
  Kerusakan Tiba-tiba: Tanpa jadual selenggara, kenderaan mungkin tidak menjalani penyelenggaraan yang diperlukan secara berkala. Ini boleh menyebabkan kegagalan komponen yang tidak dijangka atau masalah lain yang boleh menyebabkan kenderaan rosak dan terhenti di jalan. Keselamatan Terancam: Penyelenggaraan kenderaan yang teratur adalah penting untuk keselamatan pemandu, penumpang, dan pengguna jalan lain. Tanpa penyelenggaraan yang berkala, risiko kegagalan mekanikal yang boleh membahayakan keselamatan meningkat. Prestasi Buruk: Kenderaan yang tidak dirawat dengan baik mungkin mengalami penurunan prestasi. Ini boleh menyebabkan penggunaan bahan bakar yang lebih tinggi, prestasi yang lebih rendah, dan masalah lain yang berkaitan dengan kinerja kenderaan. Kos Perbaikan Tambahan: Tanpa penyelenggaraan yang berkala, kenderaan mungkin memerlukan perbaikan yang lebih besar dan lebih mahal dalam jangka panjang. Penjagaan preventif biasanya lebih murah daripada memperbaiki kerosakan besar...
Read more

Cordova CORS-CORB over laravel api server

Weird thing happens to me when Postman seem to be working fine but cordova browser says CORS. Tried using dd() just weird why Postman is working fine when the app isn't. dd() did not write proper response header (access-control-allow-origin not showing). What i learn is that Chrome require header response with  Access-Control-Allow-Origin  but Postman did not. This findings really took me a lot of hours to realize what is going on. I came to realize when i start to inspect the response header. Earlier I thought that the app is broken, but when I put other url on the same code, it's working just fine. lesson learned Chrome really hates Cross-Origin-Resource-Sharing (also tested with other web browser)
Read more