3 ms·
Really, a better solution might be to spew the results into another table and then schedule downtime and replace the original table (via rename or whatever). I
by manv1 3y ago
Really, a better solution might be to spew the results into another table and then schedule downtime and replace the original table (via rename or whatever).
It all depends on your database, which is why you need an actual DBA role on your team instead of just using your database like an abstract storage entity.
- alex_lav 3y ago> It all depends on your database, which is why you need an actual DBA role on your team instead of just using your database like an abstract storage entity. People seem to be getting along alright without it, no?
- manv1 3y agoThat's true, but that's sort of suboptimal. I mean ideally you would want someone on your team who understands how the technology behind your product actually works and how to use it efficiently. "We built this awesome tower. The foundation? It's great so far, I guess. But we really are tower builders, not foundation builders." - The team behind the Leaning Tower of Pisa The Leaning Tower stands today, so obviously they built their tower really well. But the problems with the foundation takes away from it somewhat.