May 21, 2012

Post: Getting around optimizer limitations with an IN() list

… “search within x numer of miles” function ? Thankful for any tips you can throw my way.. J A few people commented… why these sorts of geographic search queries are problematic in MySQL, it’s best to show some execution plans on dummy… a missing feature of the MySQL optimizer – and it has to do with using x BETWEEN 30 and 40 (and it’s also…