Is there any way to improve the performance of range searches? Most queries in my app (cribq.com) do a lat/long range search. When that is disabled, the performance is 5X faster. Have a look at the queries below (ignore Ferret references - that is what I used before). All of the ranges are defined as NumberValueRangeProcessor with the prefix set as as the face name (e.g. post_time) followed by a colon, so even though those look like term searches, they are not. Thanks. W[20081031T233237Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233237..20081103003237 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND city:sfbay W[20081031T233238Z] Ferret query completed in: 0.297584 with 60 results W[20081031T233238Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233238..20081103003238 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND city:sfbay W[20081031T233238Z] Ferret query completed in: 0.310786 with 60 results W[20081031T233251Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233251..20081103003251 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND ((geo_lon:5748589..5765700 AND geo_lat: 12773315..12780718)) W[20081031T233253Z] Ferret query completed in: 1.415988 with 60 results W[20081031T233254Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233254..20081103003254 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND ((geo_lon:5748589..5765700 AND geo_lat: 12773315..12780718)) W[20081031T233256Z] Ferret query completed in: 1.603946 with 60 results
Is there any way to improve the performance of range searches? Most queries in my app (cribq.com) do a lat/long range search. When that is disabled, the performance is 5X faster. Have a look at the queries below (ignore Ferret references - that is what I used before). All of the ranges are defined as NumberValueRangeProcessor with the prefix set as as the face name (e.g. post_time) followed by a colon, so even though those look like term searches, they are not. Thanks. W[20081031T233237Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233237..20081103003237 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND city:sfbay W[20081031T233238Z] Ferret query completed in: 0.297584 with 60 results W[20081031T233238Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233238..20081103003238 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND city:sfbay W[20081031T233238Z] Ferret query completed in: 0.310786 with 60 results W[20081031T233251Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233251..20081103003251 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND ((geo_lon:5748589..5765700 AND geo_lat: 12773315..12780718)) W[20081031T233253Z] Ferret query completed in: 1.415988 with 60 results W[20081031T233254Z FQQ] Search query (limit: 60, page: 0): post_time: 20081024233254..20081103003254 AND listing_type:(apa OR abo OR fee OR nfb OR aiv) AND ((geo_lon:5748589..5765700 AND geo_lat: 12773315..12780718)) W[20081031T233256Z] Ferret query completed in: 1.603946 with 60 results