News for hackers. Stuff that matters.

A comment on What SQL Analysts Need to Know About Python (2016). Parent comment

Re:What SQL Analysts Need to Know About Python (2016) by hombre_fatal on Monday November 04, 2019 @02:07PM (#21445184)
I like having some sort of db:seed task during early development that seeds 1MM+ rows in all of your tables to help you experience performance issues as they're created.

It's even more important if your production application has millions of rows. Too easy to create a system that runs perfectly on 10 rows but will crash your production server as soon as you deploy it. Forgetting to create an index on the FKs is a classic one.

[ Parent | on HN ]
Re:What SQL Analysts Need to Know About Python (2016) by overcast on Monday November 04, 2019 @02:32PM (#21445472)
Yes of course, but let's be realistic, would the people doing this type of clueless work, bother to seed a database? It's a self fulfilling prophecy of naivety. It's like all of the investing and saving advice on Yahoo Finance. The people reading it are already the ones doing it, because they are interested in learning more about it.
[ Parent | on HN ]