[Xapian-discuss] get_document loop really slow after index update (PHP bindings)

[Matei Pavel]

Hi,

(sorry if this email gets out more than once - Yahoo keeps putting it
back into my drafts folder and I haven't received in the daily digest
either)

I posted this question before but since my other email sometimes goes
into spam folders and my latest updates to the issue got no replies,
I'm re-posting with all details here:

I'm using the PHP bindings to do a search on about 30-40.000 indexed
documents that returnds 500-1000 results. The actual search takes
under 200 miliseconds but the mset iterator loop (that calls
get_document) takes anywhere from 5 to 21 seconds. This only happens
for searches made after the index has had some updates.

step 1: search for "word". loop takes 5+ seconds
step 2: search for "word". loop takes under 200 miliseconds
step 3: add document to index
step 4: search for "word". loop takes 5+ seconds.

Here is the oprofile callgraph: promotii-reviste.ro/oprofile-callgraph.txt

Here is the PHP code I'm using: promotii-reviste.ro/php-code.txt

Can anyone shed some light as to why this is happening?

Thank you.
Matt