On Thu, 19 Mar 2020 20:13:33 -0000 (UTC)
Martin Gregorie  wrote:

> Most SQL performance problems, IME anyway, boil down to crap database
> design, meaning bad or nonexistent normalisation and incorrectly placed
> or missing indexes.

 One more in a mature system - feature creep. The database was fine
for the original spec but nobody optimised for the new queries and tables
that got added for new features and worked fine testing the new features
against live data - it's just a pity what it did to the performance
under load once they got heavily used.

--
Steve O'Hara-Smith                          |   Directable Mirror Arrays
C:\>WIN                                     | A better way to focus the sun
The computer obeys and wins.                |    licences available see
You lose and Bill collects.                 |    http://www.sohara.org/

--- SoupGate-Win32 v1.05