[Xapian-discuss] multiple database search performance

[Alain Denzler]

Thank you for your reply.
I am using xapian 1.2.10 on a ubuntu server machine with php bindings. 
All the databases are locally saved.

I did some time measurements and have tracked down the slow search to 
the line

     $matches = $enquire->get_mset($offset, 10);

which is the just the basic search. Altough the rest of the code might 
not be written in the most effective way, this is the line which takes 
really long to execute. So this should be either with xapian or the php 
bindings? Or can it be a corrupted database? If yes, searching only the 
corrupted database should be slow to, i think?
> This is not what I'd expect at all; searching across multiple
> databases has a small overhead but shouldn't really be significantly
> slower than searching the component databases.  Either you're doing
> something wrong, or there's a bug.
>
> Let's try and work out which.  For starters:
>
> When you say you're searching across multiple databases, are you
> searching across them locally, or using the remote database protocol?
> What OS and version of Xapian are you using?
>