I am having a system which receive data from around 30K gps . Each unit will be inserting concurrently around 1 minute. What tweak should I add to cater for this? I target my ram to be 48Gb with 24 cpus.
Once the data grow should I do partition or leave it . I am worried as the data grow the insert will be slow?
[*]What should I anticipate and handling for heavy traffic?