" /> kasia in a nutshell: May 2006 Archives

« March 2006 | Main | June 2006 »

May 25, 2006

Oracle optimizer is pure voodoo

A problem we ran into at work today..

A table with mucho data and a date column. The date column has an index on it and its type is just pure old date. A query using jdbc and java.sql.Timestamp type on a prepared statement generates a full table scan.. and the associated slllloowwwwwnnnessssssss.

Identical query using java.sql.Date on a prepared statement or to_date(String, format) in the SQL uses the index.

Am I missing some obvious Oracle clue here? Cause google isn't helping!

Edit: I realize we can hint to Oracle which indexes to use, but it would be nice to have a more general solution.

May 21, 2006

Images from JavaOne


Here's my collection of pictures from this year's JavaOne. I divided it into three categories:

  • General images from around the city. Mostly from touristy spots.
  • Musee Mechanique is a little museum of old amusement machines located at Fisherman's Wharf. Some are interesting, some fun but most are definitely in the creepy category.
  • This year's JavaOne backpacks were a fashionably-stark orange. It made spotting the geeks rather easy. I dedicate this last collection to the designers of the backpack. Good work.

Note: these were all taken with a 50mm prime lense, so "zoom" is created with photoshop.

May 19, 2006

JavaOne

Good conference this year. Went to some really good sessions and only a couple turned out to be duds so I'm definitely batting better than last year. I like the new session enrollment requirement and like it even more than Sun decided to repeat some of the most popular sessions. I'll be attending three of them this afternoon.

In the first general session, we were told it's the biggest JavaOne conference to date and I can certainly believe that looking at the lines to the sessions and crowds everywhere. What surprise me (pleasantly) was the amount of women this year. Nearly made me cry to see an actual line to the ladies room yesterday.

I'm sitting in the alumni lounge right now waiting for my next session ("Using Service Component Architecture to Wire BPEL Processes to Java™ Technology-Based Components" at noon). Only one other woman at the lounge beside me right now, but I'll bet it'll look better next year.

It's good to see that Java is pretty healthy and conference is doing well. Now if only Sun didn't come up with that hideous, orange color for the backpacks. You can spot the geeks all over town from half a mile away thanks to those. Pictures coming up soon!

PS: If you're in SF right now, awesome cream puffs in a little place accross the street from Yerba Buena Gardens (behind Moscone North). Worth the 2min walk!

PPS: To the geek who accidentally wondered to the ladies room and ran out horribly embarassed once he realized it: Sorry I laughed so hard dude!

May 05, 2006

If one post could define a site..

Then this one truly represents and defines the spirit of Craigslist. Inspiring.

May 01, 2006

When geeks have nightmares

Geeks are humans too. If you prick us, do we not bleed? As Shakespeare once wrote[0]. Being human we have bad dreams just like the rest of the population. It's just that ours are more amusing later in retelling on a weblog.

As my own example from last night shows..

My most recent nightmare?

Suddenly realizing it's the last day of JavaOne and I missed all sessions.

Yes, I really had that nightmare last night.


[0] I doubt he had computer programmers in mind, but, in his own way, he was a geek for his own time. Sort of. That really explains the whole ren-faire thing though, doesn't it?

Kind of a cute little bug

Either too many of my friends have recently become avid yahoo game addicts or some recent yahoo messenger server update screwed up the icons on mac os...

PS: yep, still alive, just busy!