optimize database

How To Fix WordPress Database Error

If you are using wordpress or other cms and have a lot of data in you sql, your site usually will unavailable with common message database error. What actually error on your database? Nothing, this is all about query limitation on your hosting. Your blog will grown in time, say in the last months you got 10,000 readers and in the next month you got 1,000,000 readers. When people access your site it’s continuously reading data again from your database, when it to much some hosting will stop it to executed. This is not good for SEO because your potential… Read More »How To Fix WordPress Database Error

CRON JOB to Repair and Optimize Database

In this short articles we will learn how to automatically repair and optimize our database using Cron Job. Cron Job is most likely scheduler, mean it will run automatically after we setup it. I believe not many of us know how to using this features, We can use it to run periodically some PHP script we made. Example a sitemap generator script which may consume to many resource if we run it manually, we can set it run in schedule follow settings on Cron Job. In this short articles I will give sample how we can use Cron Job to… Read More »CRON JOB to Repair and Optimize Database