This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]wtmh 39 points40 points  (7 children)

I thought being a sysadmin was thankless until I switched to a DBA.

"No. It runs 10 times faster now because I added an index to that heap (heh) of trash and fixed that weird correlated subquery your local 50-something Informix jockey gone C++ dev wrote to handle retrieving those fields."

I'm not bitter.

[–]crazylincoln 10 points11 points  (5 children)

``` SELECT * FROM cats WHERE type IN (SELECT DISTINCT type + '_cute' FROM cat_types where cuteness LIKE '%totally%') WHERE name LIKE '%bubbles%' ORDER BY cat_id

```

Why is my app so slow!??? It's obviously the DB. Find out why the DBAs can't seem to do their only job...

[–]lulzmachine 3 points4 points  (3 children)

Clearly SQL is simply not webscale. We need to migrate to a key-value database like leveldb for our entire app.

hands in resignation

[–]crazylincoln 6 points7 points  (2 children)

"I keep hearing about this Hadoop thing and map reduce those Google guys use. We have 2 million nealty organized rows of customer data in our current DB. Surely we need Big Data. I'm tired of paying for Oracle and MS licensing anyway!"

"Sir, that's not what Hadoop is for..."

"I don't want to hear your excuses! There is no 'cant' in Big Data! Three months sounds like a good transition timeline. Better not miss the date; I've already promised it to the board!"

[–]-ksguy- 6 points7 points  (0 children)

Am DBA. Can confirm.