Please provide more data. Specifically:
> how many documents are updated?
> Have you tried running this query without Solr? In other words
have you investigated whether the speed issue is simply your
SQL executing slowly?
> Why are you selecting the last 10 hours' data when all you want
is the last hour?
You could always partition the problem to multiple threads if you
really have that many documents to update, but I'd look at the
efficiency of your SQL query first.
Best
Erick
On Tue, Nov 30, 2010 at 8:50 AM, stockii <st...@shopgate.com> wrote:
>
> 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.
>
