Implementing Output Caching in PHP – Solve Perfomance Issues

Cache by definition is transparent storage where results can be stored, so that the future requests can be served faster. With the amount of data handled ever growing, and the necessity for caching has become unavoidable in any decent size web application. In this series, I’d try to bring out various alternatives available in PHP for efficient caching.
Continue reading Implementing Output Caching in PHP – Solve Perfomance Issues

Scheduling MySQL Backup..!

    There have been instances when we need to schedule the backup process of MySQL databases regularly. So I thought of writing batch file that can be added in the Windows scheduler. I used the ‘mysqldump’ utility that comes with the MySQL distributions. It dumps the database definition along with all the data, indexes, triggers and SPs in the form of .sql file. I’ve also made the batch file to compress the output .sql file.

Continue reading Scheduling MySQL Backup..!