Thoughts from a Coding Mommy

Wednesday, April 04, 2007

Bad Sleeper

Long time, no post. I'm at 31 weeks and have been very tired so no more late night coding and blogging.

BUT I've been up since 3:30am due to my little guy being a bad sleeper. I try to not go in there when he wakes up in the middle of the night but I'm weak. And he doesn't like to sleep in our bed so I have to sit with him in his room. Lately, he likes to fall asleep while I hold him sitting in my comfy chair. (I used to have wooden glider but the soft cushy rocker that I treated myself to this past Christmas has really paid off!) I love him. He wants his mommy. How can I say no?

I actually coded something tonight that was nice. Well, they say functionality first then optimization. But I should have been a little more proactive about this optimization in the first place. Oh well. I took a bunch of small, fast queries and rolled them up into one big fat in-clause query. Overall, FASTER! Roundtrips to DB vs. slicing-and-dicing in Java code, no brainer. But the best part is that there is a way to create a function to generate the in-clause so that we can take advantage of prepared statements and Oracle query caching. I learn so much from our DBA. I'll post that if I get the chance. I need to follow up tomorrow...er, today to get the 411.

0 Comments:

Post a Comment

<< Home