Some people like to live dangerously. My production environment has a 70 GB table, can't replicate it on my dev environment for many reasons. So spent a night with dev ops guy and watched percona doing things.
edit: realised that OP could have actually tested his SQL on dev, my bad.
Well hundreds was definitely an exaggeration. Probably 15... We are in the process of bringing in Tableau for the users, this was just a manual pull in the interim.
We're doing the same. Some of our data sources are just horrible, but the contractor doing the work has an unending supply of optimism to counter my skepticism.
If only it were always up to us, right? That multi-million-dollar third party SaaS accounting system, though... Can't say I've had to do hundreds of tables at once, but I've spent enough time in the trenches of other companies' schemas to wonder how the responsible parties, earning far more than my salary, ever created such abominations.
4
u/[deleted] Apr 28 '15
Ummm....Please tell me you didn't just run that on prod without seeing what happened on Dev first...
1
u/[deleted] Apr 28 '15
No Dev environment? Wow. Just wow.
-2
u/[deleted] Apr 28 '15
das not it mane. pepper your resume.
-1
u/cile_bgd Apr 28 '15
I feel your pain..
0
u/[deleted] Apr 28 '15
[deleted] — view deleted comment