lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Almgren <s...@tras.se>
Subject Re: DIH delta, deltaQuery
Date Thu, 25 Nov 2010 08:49:18 GMT
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 <stock@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.
>

Mime
View raw message