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.
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