klokantech/osmnames-sphinxsearch

Country_code to be indexed

klokan opened this issue · 2 comments

klokan commented

It could be practical to index in the fulltext search also the country code for short queries, such as: 'Zermatt, CH'. The "CH" is now not part of the fulltext index, it seems.

MartinMikita commented

http://osmnames.klokantech.com/?q=Zermatt%2C+CH&format=html&debug=1&autocomplete=1

World data reindexed

indexing index 'ind_name'...
collected 20735819 docs, 1917.5 MB
sorted 271.4 Mhits, 100.0% done
total 20735819 docs, 1917517333 bytes
total 802.449 sec, 2389581 bytes/sec, 25840.66 docs/sec
indexing index 'ind_name_soundex'...
WARNING: index 'ind_name_soundex': dict=keywords and prefixes and morphology enabled, forcing index_exact_words=1
collected 20735819 docs, 1917.5 MB
sorted 542.8 Mhits, 100.0% done
total 20735819 docs, 1917517333 bytes
total 859.412 sec, 2231196 bytes/sec, 24127.90 docs/sec
total 41500382 reads, 408.134 sec, 0.5 kb/call avg, 0.0 msec/call avg
total 66398 writes, 74.436 sec, 449.9 kb/call avg, 1.1 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=30).

real    27m41.871s
user    14m33.788s
sys 0m57.744s

Result size is 15 GB, 14 GiB - only 241 MiB larger than without this field.