Are you running optimization after this query?
If you check the command=status page I'd guess that the document count
has stopped after a few seconds?
/Sven
On Wed, Nov 24, 2010 at 13:06, stockii <st...@shopgate.com> wrote:
>
> Hello.
>
> i wonder why this deltaQuery takes over a minute:
>
> deltaQuery="SELECT id FROM sessions
> WHERE created BETWEEN DATE_ADD( NOW(), INTERVAL - 1 HOUR ) AND
> NOW()
> OR modified BETWEEN '${dataimporter.sessions
> .last_index_time}' AND
> DATE_ADD( NOW(), INTERVAL - 1 HOUR ) "
>
> the database have only 700 Entries and the compare with modified takes so
> long !!? when i remove the modified compare its fast.
>
> when i put this query in my mysql database the query need 0.0014 seconds
> ... wha is it so slow?
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/DIH-delta-deltaQuery-tp1960246p1960246.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
