[Xapian-discuss] Two questions

[Olly Betts]

On Tue, May 03, 2005 at 03:44:41PM +0200, roki roki wrote:
> I get the same values for all three functions for get_mset(0, 10)
> estimated: 198844
> lower_bound: 198844
> upper_bound: 198844

OK, so we've had to consider at least 198844 documents.   In fact since
the bounds are equal, we must have considered all the documents which
could possibly match I think.

> The queries are not always slow so it is maybe some load problem on my
> server? 

Most likely it will depend on whether the disk blocks needed are cached
or not.  If they aren't, things will be slower.

> Quartzcompact the database reduced with more then 60% !? and after that
> queries are FAST, but I do every day a lot replacing in database.

Do you mean "reduced by 60%" (rather than "reduced to 60%")?

"By 60%" would be quite an extreme reduction (even by 40% is rather more
than I've generally seen), but lots of replacement can leave blocks less
full.  If you can provide a program and datafiles I can use to reproduce
this, I'll take a look and see if this can be improved.

Cheers,
    Olly