[Xapian-discuss] Performance of range searches

[Alex Neth]

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