[Xapian-discuss] Remote database search issues

[Ron Kass]

Answering myself for the first question, the right stub line format for 
ssh is this:
    remote :ssh ftsuser at 10.0.0.27 xapian-progsrv /data/fts/Database2/
Notice the colon before the ssh. colon has to be the first char in the line.

Searches are considerably faster than over tcp. No idea why.
Getting documents and matching words is still very bad though.
if we have to get data of 25 results, since our internal document ID is 
store there for identification, it takes about 0.03-0.04 per document to 
fetch. that is almost a second only for document fetching. AND thisis 
for second time fetch. This is very slow. I read somewhere that 
documents can be somehow fetched in batches? Is that right? if so, 
anyone knows how/if can it be done in perl?
On top of that, getting matching words takes an extra 2 seconds to 
sometimes much much more. especially first time searches where it can 
take even 20 seconds for a specific document.

Any ideas?
Cheers,
Ron

> 1) Only the xapian-tpcsrv worked. We couldn't figure out how to use 
> xapian-progsrv. The problem was the stub file format.
> This works:
>    remote 10.0.0.27:33333
> But these don't work
>    remote ssh ftsuser at 10.0.0.27 xapian-progsrv /data/fts/Database2/
> or
>    remote ssh 10.0.0.27 xapian-progsrv /data/fts/Database2/
>