… 288124661 # This item is included in the report because it matches –limit. # Scores: Apdex = 0.97 [1.0], V/M = 19.02…
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… using index and filesort may be too slow for many matches. Though in reality problem can get even more complicated because… function, for example by distance or using some sort of scoring system.
Comment: ORDER BY ... LIMIT Performance Optimization
October 23, 2006 By 100 Comments
Sorry, sql should read: SELECT * FROM WHERE MATCH(text_field) AGAINST(‘text’) ORDER BY score DESC
