Super simple ways to optimize MySQL query
1
Steps: 1. Enable Slow Queries Log In MySQL 2. Enable Query log Not Using Indexes (log_queries_not_using_indexes) 3. Add Index and Foreign Key Constraint To Improve Query Speed 4. Avoid Duplicate Indexes 5. Remove Unused Indexes From the MySQL Table 6. Ana
Popular Articles by this blogger
- Unique jQuery Validation Success Message Using jQuery Validation Plugin
- Pagination, Previous, Next, First and Last button using jQGrid, PHP, MySQL, jQuery and Ajax
- jQGrid PHP inline Editing with Pagination, Previous, Next, First and Last button functionality
- Book Irctc tatkal tickets easily though IrctcEasyBook.com
- Smart Tutorials Demo Page
- Live Username and Email Availability Checking using PHP, jQuery and Ajax
- https://smarttutorials.net/learn-jquery-autocomplete-in-3-minutes/
- Create Chrome Extension for your Blog in 2 minutes that shows recent posts.
