Increase the Performance of Ruby on Rails Applications

Although the development of applications is fast in Rails, the applications themselves are often a bit slow. The elegant framework increases the productivity of the programmer but reduces the performance of the application. The DRY principle is great to prevent code repetition, but it is less optimal to increase speed: it is of course much [...]

Read Full Post »

The key to a high-performance site

“caching! caching! caching!”, see for example the Wikipedia Infrastructure

Read Full Post »

Performance for SELECT using LIMIT and OFFSET

Pagination of long lists often works with SQL queries like the following one with an offset O and a limit number N:

SELECT * FROM table ORDER BY something LIMIT O, N

THe WILL PAGINATE plugin for example produces queries like this. They can be awful slow if the offset O is very large. A [...]

Read Full Post »