Elasticsearch jdbc river import slow

Question

I'm trying to import a sqlserver database to ES with jdbc river but the import process is very slow. In the logs I see that the process is doing the import 1 by 1:

new bulk [58] of [1 items], 1 outstanding bulk requests
bulk [58] success [1 items] [116ms]
new bulk [59] of [1 items], 1 outstanding bulk requests
bulk [59] success [1 items]

How can I speed up the process?

score 0 · Accepted Answer · answered Apr 29 '13 at 06:17

0

The problem was with my sql sentence. There was a left join that was doing that the performance of the query goes really down, so the import was slow too.

answered Apr 29 '13 at 06:17

David Sedeño

495
1
6
19

Hi David, can you share the JSON you used to setup the river?? I spending days on it without any success. I can't make it index my sql tables. – Kulpemovitz Jun 24 '13 at 12:22

Elasticsearch jdbc river import slow

1 Answers1