Thank you for such a thorough and we'll explained answer.
When you take nearly 20 years of data and allow it to be searchable and accessible to reuse, it chews up CPU for sure.
This site also has an enormous amount of graphics, gifs and videos that add to the crush.
Could an archive DB be setup to house a lot of older stuff that is still accessable but not always indexed and updated?
I recall a large medical company like Merck or someone similar had an issue like this.
|