[Xapian-discuss] Unexpected slowness

[Olly Betts]

On Thu, Jan 25, 2007 at 10:02:59PM +0200, Daniel Andersson wrote:
> On both the development machines the searches run as fast as expected  
> but on the live machine (Linux 2.4.22) the searches take seconds (2-7  
> seconds). And the live machine is much faster than the devel machines.

What do you mean by "faster"?  Raw CPU speed isn't usually the limiting
factor for a large database - does it have at least as much RAM and a
disk subsystem which as at least as fast?

Also, is the live machine doing a lot of other work?

> The index is split, sub_index_0 = 1.7 GB, sub_index_1 = 50 MB, and  
> it's a Flint database/index.
> 
> Got some information from xapian-config (not sure if it's helpful or  
> not):

No, that's just where you've installed Xapian - it's not relevant here.

> quartzcheck (couldn't find any flintcheck, but quartzcheck seems to  
> be happy) returns the following:

There isn't currently a program for checking flint databases.

Both flint and quartz use essentially the same Btree table manager but
the structure inside these isn't quite the same and the names are
different ("." rather than "_") so quartzcheck should be able to
successfully check a flint database (it failed when I just tried it).

What does "ls -l sub_index_0" show?

Cheers,
    Olly