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.
