Well, had a brief phone interview this week with a company that has a job that is actually in Toronto this week. That lead to a programming skill test, which I almost bombed because I spent too much time learning SQL and managed to miss the part where I was supposed to do all the hard work in Perl until near the end. Sadly the articles I'd read on how to do efficient querying in SQL did not predispose me to doing large numbers of unnecessary queries.
I know that SQL ability isn't what they were testing, but the part of me that learned programming on 8 bit micro-controllers with severely limited memory was crying quietly inside at the waste. I hope that the comments I included to the tune of "Here's the 10 lines of Perl to do what you want, and here's an SQL SELECT statement that does the same thing without having to return every row in a 10,000,000 row table to me." will not come across as too frustrated.
--
"Speaking of sleep, last night I had my first stress dream of
my current job. It was almost like old times!" -- Malcolm Ray
I know that SQL ability isn't what they were testing, but the part of me that learned programming on 8 bit micro-controllers with severely limited memory was crying quietly inside at the waste. I hope that the comments I included to the tune of "Here's the 10 lines of Perl to do what you want, and here's an SQL SELECT statement that does the same thing without having to return every row in a 10,000,000 row table to me." will not come across as too frustrated.
--
"Speaking of sleep, last night I had my first stress dream of
my current job. It was almost like old times!" -- Malcolm Ray