Is there a large variance in xapian searching?
morefreeze <[email protected]> Mon, 2 Jul 2018 18:08:40 +0800
| Newsgroups | gmane.comp.search.xapian.devel |
|---|---|
| Message-ID | <CAAf+yRp-cz7A2eN_CgvgLZGaBoNQ-WY640pV==63P0DUqbOQ2A@mail.gmail.com> |
Dear XAPIAN developers, I was using xapian to index large than 13 million document about Q & A(Quora similarly). I will share some performance data about indexing and searching, and I will seek some help for improving performance of searching. My computer has 8 [email protected] CPU and 16G memory, ubuntu 16.04. Dataset include about 13M document, each document will be cut into 35 term(Chinese word) on average. I adopted split-merge algorithm as well. I built each index which contained 500K data and then merged them into one databases. Building smaller databases cost 2 min 40 s on avg. Compacting them cost about 2 hr 12 min. I found every first time(like after booting computer) or sometime(occasional) to query(use QueryParse) this databases will cost significant seconds (like 5 seconds), although it cost 0.8 seconds on average. What is the reason of this? Or how can I debug this, I mean where can I add some LOGLINE to measure these time? If I want to shorten this query time what should I do or try? BTW, I think splitting more databases and query them parallelly is not a good idea, unless xapian ensure each query is less than a expected time(Actually this 13M database is 'small', :P). -- One of my most productive days was throwing away 1000 lines of code.