Hello.

index is about 28 Million documents large. When i starts an delta-import is
look at modified. but delta import takes to long. over an hour need solr for
delta.

thats my query. all sessions from the last hour should updated and all
changed. i think its normal that solr need long time for the querys. how can
i optimize this ? 

deltaQuery="SELECT id FROM sessions 
WHERE created BETWEEN DATE_ADD( NOW(), INTERVAL - 10 HOUR ) AND NOW() 
OR modified BETWEEN '${dataimporter.last_index_time}' AND DATE_ADD( NOW(),
INTERVAL - 1 HOUR  ) "  
-- 
View this message in context: 
http://lucene.472066.n3.nabble.com/Best-practice-for-Delta-every-2-Minutes-tp1992714p1992714.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to