Posted in development, tagged limit, MySQL, offset, Pagination, performance, select, sql on November 6, 2008 | Leave a Comment »
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 [...]
Posted in development, tagged MySQL, search, Sphinx on November 3, 2008 | Leave a Comment »
Sphinx is a free open-source SQL full-text search engine, and quite useful for fast full-text search. If you get the error
ERROR: index ‘main’: sql_fetch_row: Lost connection to MySQL server during query
during indexing of a large database with Sphinx (large means more than 500.000 rows in a table), then it may help to increase [...]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Oct | ||||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | ||||||
 | vesters on Using Web Services in Rub… |
| vesters on Using Web Services in Rub… |
 | Marvin on Object matching in Ruby |
 | Adrian on Ruby and AOP |
| DSL for Finite State… on DSL in Ruby |
