[Xapian-discuss] Long query times

[James Aylett]

On Thu, Sep 29, 2005 at 10:39:38AM -0400, tech at dbx.co.uk wrote:

> I've created a Xapian db of CVs submitted to the company I work for
> (~800,000) to give a directory of ~6GB. Unfortunately some of the searches
> can take several seconds to complete, and this gets dramatically worse for
> concurrent queries.

Are there particular types of query that are taking longer? eg: phrase
searches, or more than a certain number of terms?

> Any ideas as to what I could do to speed things up? One potential problem
> is that the index is not really aged as old CVs may be updated as well as
> new ones.

You could get some improvements by searching against a compacted
database, updating a non-compacted one and then regenerating the
compacted one regularly.

> The machines are reasonably specced (dual 2.4Ghz Xeons with 5GB memory)

What OS?

J

-- 
/--------------------------------------------------------------------------\
  James Aylett                                                  xapian.org
  james at tartarus.org                               uncertaintydivision.org