[0] https://www.fda.gov/about-fda/nctr-location-facilities-servi...
[1] https://www.arkansasonline.com/news/2023/aug/30/monkeys-gone...
They don't really work with indexes but instead regular files stored in partitions (where date is typically one of them).
This means that they only have to worry about the data (e.g. dates) that you are actually querying. And they scale up to the number of CPUs that particular calculation needs. They rarely choke on big query sizes. And big tables are not really an issue as long as you query only the partitions you need.
Of course with 20/20 hindsight that decision is easy to criticize. I suspect their primary concerns were to minimize risk and costs while meeting our customer's requirements. Even today, making a brand new Google product or Facebook backed open source project a hard dependency would be too much risk for an established business.
That difference might go some way towards explaining why I prefer a much more database heavy/thick approach to writing apps than my peers.
I was first introduced to the issue of needing hyper optimized SQL in ETL type tasks, dealing with very large relational databases. The company switched to non-relational database shortly after I left, and it was the first time I professional witness someone make the switch and agreed that it was obviously required for them. We were dealing with very large batch operations every night, and our fortune 500 customers expected to have the newest data and to be able to do Business Intelligence operations on the data every morning. After acquiring bigger and bigger customers, and collecting longer and longer histories of data, our DBA team had exhausted every trick to get maximum performance from SQL. I was writing BI sql scripts against this large pool of SQL data to white-glove some high value customers, and constantly had to ask people for help optimizing the sql. I did this for a year at the beginning of my career, before deciding to move cities for better opportunities.
Lately, I've began seeing the requirements of high performance SQL again with the wave of microservice architectures. The internal dependency chain, even of what would have been a mid size monolith project a decade ago, can be huge. If your upstream sets a KBI of a response time, it's likely you'll get asked to reduce your response time if your microservice takes up more than a few percentage points of the total end to end time. Often, if you are using relational SQL with an ORM you can find performance increases in your slowest queries by hand writing the SQL. Many ORMs have a really good library for generating sql queries they expose to users, but almost all ORMs will allow you to write a direct sql query or call a stored procedure. The trick to getting performance gains is to capture the SQL your ORM is generating and show it to the best sql expert that will agree to help you. If they can write better SQL than the ORM generated than incorporate it into your app and have the SQL expert and a security expert on the PR. You might also need to do a SQL migration to modify indexes.
So in summary, I think your experiences with SQL depends heavily on your mathematical background and your professional experience. It's important to look at SQL as computational steps to reach your required data and not simply as a way to describe the data you would like the SQL server to give you.
If it was completely AI generated without any human intervention, it likely would have been fairly generic / poor writing anyway. At least for the time being, AI is a new tool at our disposal but it's still just a tool, like a calculator or a hammer.
Students should be judged on the merit of the work even if some of the work is AI generated.
Example: no one cares that you wrote 5 pages on To Kill a Mocking Bird. They care that you read the book and thought critically about it. AI allows students to skip the reading and critical thinking portion, which is the most important part.
Is it more humane to launch it without testing, producing the same effect for a much, much larger group of people than would have been involved in the intentional study? This seems to be a fairly gaping hole in the definition of humane. It reminds me of people who see an accident and don’t help because they might be held liable for the accident and they don’t want to get involved.
Could you elaborate on why this is a problem? It seems to me that there is not inherent right to introduce new chemicals into our lives, and I would prefer this not be done without thorough risk assessment studies.
In the medical industry, introducing a new medicine requires years of testing for something that will be given to a tiny slice of the population. I find it odd that there does not seem to be a similar process for chemicals that could be spread throughout the entire population.
* We are often creating chemicals that do the job of existing chemicals safer and more efficient. This ban would probably include a grandfather clause for old chemicals, and thus we might be using inferior products and doing more harm than we otherwise could. Look at refrigerants as an example of a chemical compound that has improved over the decades.
* Many chemical compounds introduced in the last 100 years directly improve productivity. The United States is in economic competition with other regions of the world. We could be creating a disadvantage that reduces our geo-political power.
* Many of these chemical compound increase quality of life. There's a strong unitarian argument for sucralose and polyurethane insulation.