Archive › October, 2010

Improve query speed in the MySQL for large data

by on October 19, 2010 in LAMP, Performance Optimization

I was executing select query which had 4-5 table join on large data set for report and query was taking too much time or not giving any result even after an hour even tables were proper indexed. Later on I started to find out the reason of this behavior and found that there is some [...]

Comments Off

Backup and Restore a Large MySQL database

by on October 16, 2010 in LAMP

Recently I was working on a large web-application and had to port it to new server. The main challenge was how to take the backup of the huge database and restore it on new server. Phpmyadmin was not able to take the backup of the database because of timeout issue with Apache. So I decided [...]

Comments ( 1 )

Minify, Compress and Synch your assets on Amazon S3 using Capistrano and Rails

by on October 2, 2010 in Ruby on Rails

I hope every one is aware of Amazon’s S3 service and using this service for Static contents like JS/CSS/Images. It’s a wonderful storage server with high-performance and reliability at fairly low price.I am using this service for my project and main challenge was to automate the process of uploading the static contents on the S3. [...]

Comments Off