MySQL LIMIT Optimization

I have this scenario where MySQL LIMIT syntax is very slow for table having 30 million records.

Solution
Instead of using MySQL LIMIT you may use WHERE and BETWEEN which works pretty fast.

Proper Indexing of Tables in MySQL

In general you should only add indexes to match the queries your application uses, any extra will waste resources. In an application with very small tables, indexes will not make much difference but as soon as your tables are larger than your buffer sizes the indexes will start to speed things up dramatically.

Hudson Installation Procedures

Overview


Hudson is a Continuous Integration (CI) server which polls a version control repository and runs an automated build soon after a change is detected in the version control repository. Hudson organizes CI jobs into projects. Each project has its own build script and its build results are stored within Hudson's work area.