Quote:
Originally Posted by Roonil Wazlib
MOD(t1.nums, 15) = 0
in oracle at least, afaik
Which is a great "old man yells at cloud" thing. Learning php, Java, and sql, I have to remember three different comparison operators for 'equals to'. What kinda bs is that?
In Lisp, you write (mod x y), so when you write "mod," know that you are using the One True Way.
I'm not sure why schools would have you using Oracle. Makes no sense at all. Once you are done, you won't be able to study Oracle unless you want to pay Oracle, which is awful.
Also, let the db-wars begin, the very things that Oracle people mock Postgres about is exactly what Postgres mocks Oracle about. Many a dead bodies have piled up over hinting. Also, Oracle has a query optimizer that is "too good." You can write some bad stuff and still get decent performance, which is kind of a backwards way of teaching SQL, in my opinion.
Quote:
Originally Posted by adios
Out of curiosity, I am curious how often O() analysis comes up in the development process where people work. I would think code reviews would be the most likely place. However, that probably is a little late in the process. I would think O() analysis comes up in a design phase but then I guess we're talking about a waterfall type development process. Where I've worked O() analysis like almost never comes up.
Not exactly O(), but in a database interview, speed of query execution is the main topic at a whiteboard. Certain topics don't matter as much, but for the most part, I've had to justify my answers with how long something will take, especially on the home tests.
Where I am, the topic of speed is paramount above all others, but the issues we are solving and dealing with sort of require it. My entire reason for existing is making the database fast.
Day one was much different than I thought it would be. I basically spent the day learning what the system is doing and then started working on some low hanging fruit. A few issues prevented me from doing so, but I feel like I understand the system and understand how I'll be useful. Oddly, I didn't feel the dreaded impostor syndrome, and I feel pretty good about this.