I have a large aggregation query that becomes incredibly slow when I am updating my data. I am not saving the data to a tmp index (and then renaming it when it's done) but saving it directly to the index I'm querying.
- What are some ways to improve querying performance while indexing is occurring?
- What are the usual bottlenecks that I'm seeing here (possibly memory?)?