Hi I am new to ES but my company is starting to use it
When I set up an river I have scheduled it to check for data changes at an
30 min interval, my largest index on dev includes 230k documents but in
production is expected to grow to 300million docs
this 230k index is a heavy load on the server when it checks for data
changes, puts the core in 100% for approx. 5 minutes.
It looks like it is reindexing the index every time, I am using simple
strategy, can someone show me where I can find documentation on the
different strategies?
here is a sample of my river statement:
{
"_index" : "_river",
"_type" : "transactions_test",
"_id" : "_meta",
"_score" : 1,
"_source" : {
"type" : "jdbc",
"jdbc" : {
"strategy" : "simple",
"url" : "db server connect string",
"user" : "username",
"schedule" : "0 20/30 * * * ?",
"password" : "password",
"index" : "transactions_test",
"type" : "transaction_test",
"sql" : "SELECT * from my_transaction_table"
}
}
},
best regards
Erlendur
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/5c27c8d2-2f00-4e18-98f9-28f2af828d9e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
