I wonder how\if elastic will handle my requirements:
20M records a day -> index 3 years backwards.
My worry is about query performance and not multiple requests. (more shards rather then more nodes)
will elastic handle this amount of data?
What is the best architecture to handle this load? ( index per day? week? )
what are the variables my performance will be effected by? my machines memory and size? will infinite memory and size support infinite data per day? (i exaggerate on purpose to learn&understands the relations between machine strength, architecture and performance of elastic)
Thanks in advance!