Lack of Inertia

I feel like I should be doing something.  Something…more.  I’m not talking about anything on a grand scale.  I just feel, right now, like I spend far too much of my time sitting idle.  Much of this is fueled by the fact that I work from home and spend most of my off-hours entertaining myself in front of my computer.  The upshot of this is that I probably spend 3/4 of my life sitting in the same chair starting at the same two screens.

So much so that, the other night, when I announced to the family at large that I was going to go out to Starbucks to grab a cup of coffee because I felt the need to just get out of the house I was met with bewilderment.  Alex ended up going with me and asked, in the car, if I had wanted to talk to him privately about something.  They couldn’t seem to grasp that there wasn’t any kind of ulterior motive to my actions.  I, quite literally, just wanted to be out of the house.  When compared to my normal activities this was something strange and unusual.

The fact that my patterns are so predictable and stagnant that the simple act of wanting to step out for an hour to grab a cup of coffee is unusual causes me some distress, my friends.

What’s more, they aren’t alone in this.  I myself have gotten to the point where things that are outside of my normal array of activity are seen as being bothersome.  I’ve started to get resentful of any time I’m asked to leave the house when I’m not expecting to, and only part of that is due to the fact that gas is so expensive.  I make decent money.  I can afford gas.  It shouldn’t be an issue if for some reason I need to go somewhere I hadn’t been planning on going, but when confronted with a situation like that I tend to get cranky. 

This lack of doing anything other than sitting at the keyboard is not limited to activities outside of the household, either.  I don’t do nearly as much around HERE any more, either.  I don’t cook or clean as much.  Home improvement projects take forever or never happen.  Yard work is sporadic at best, with things usually needing to get to a critical mass before I do anything about them.  I want to do something different with my web site, but the amount of effort required to do so simply puts me off from even starting. 

A lot of this can be attributed to the time I spend playing World of Warcraft.  I’m aware of that.  Frankly, though, my apathy and lack of inertia bleeds over into that arena as well.  I’m exceedingly bored with the current level of content we can access in our guild, and the new stuff that we’re moving in to really doesn’t excite me all that much either.   Running the guild for as long as I have has taken a toll on meas well, and I’ve gotten to the point where I’ve dealt with so much drama and bullshit that I instantly assume the worst whenever I face some sort of possible “controversy.”   As proud of I am of where the guild is and what we’ve managed to achieve, there are many times when I miss not having to juggle 100 people and their schedules, personalities, and attitudes.

Work is…work.  Again, very stagnant right now.  We’ve got a few major projects coming up but they are all in the planning stages right now and I find myself sitting around waiting for “permission” to start on projects and subsequently doing nothing.  We’ve gotten all official with Project Managers and outlines and charters and sign offs and meetings and I spend most of my time wondering if I’m even supposed to be working on something.  In the past if someone wanted me to do something and I had the time to do it I just DID IT.  Now I have to tell them they need to submit a project request and they have to wait for it to be talked to death and approved before I can even start.

It’s not very effective.  I realize it COULD be and that transition periods like the one we are going through are always painful, but that factors in pretty heavily in the “spinning my wheels” feelings I’m having right now.

I was hoping to be involved in a show or two soon, but it looks like I probably won’t be until the beginning of next year at the earliest (if at all).  I could go out for something with another company, but the fact is that finances do factor into THAT equation.  With the amount of money I spend on gas to do a show and the amount of time it takes away from my family I have to be able to turn some kind of profit in order to justify it.  I know I’m supposed to be an artist and all and that I should get satisfaction out of just being a performer, but the bottom line is the bottom line.

I’ve had a really hard time getting back into the exercise groove.  I haven’t stopped completely, but I really have to push myself to do my workouts on the days I do them.  Maya asks me how I’m feeling and I almost always tell her “You’re lucky I’m here.”  I’m back up over 250 again and currently sitting at 256, having managed to get down to 248 right after Rosencrantz and Guildenstern finished. 

Healthy living requires motivation.  I think the tone of this post makes it pretty clear I have none.  Want and need to quit smoking again, but can’t muster enough “care” up to do that either.

So yeah, that’s where I’m at right now.  Maybe it’s just a phase I’ll shake off, or maybe I need to make some big changes in my life.  Maybe I just need to turn off the damn computer more.

I’m just not sure.

Saturday, June 21st – Television Preview

I have four tickets to a Television Preview in Clearwater that I cannot use because I have friends coming over to hang out. If anyone would like them they are welcome to them.

Just as a heads up – This isn’t a scam of any kind. The reason I got the tickets is because I’ve been to one before, and it’s everything they advertise it to be. They’ll show you a few half hour shows, get your feedback, and give away some door prizes. I can’t remember if they actually bothered to give out refreshments or not, but I think they did (it’s been a while). The shows I saw when I went were pretty awful and none of them made it on the air, so I can’t make any promises that you’ll actually be ENTERTAINED (unless, that is, you like bad television). They also won’t bug you a lot if you give them your contact information. This is the first contact I’ve had from them since the last event I went to and that was over 12 years ago.

Cross posted to tampa

Eddie Izzard

Well…that was kinda…meh.

Funny at points, but not the laugh riot I’ve come to expect. I suspect a lot of it had to do with the fact that he was exhausted. His energy seemed really low, and he mentioned not being able to do a sound check due to some kind of hectic scheduling issues. Which, in all honesty, showed. The sound levels were not right. Apparently the folks in the balcony and further back could hear him fine, because they were laughing at jokes that we (in the third row) couldn’t understand. I dunno. Hopefully he’ll be better tomorrow night for those of you who are going to see him, but overall…I just didn’t laugh that much.

If you’ve ever had me in one of your audiences, you know that’s not a very common thing.

Update

So, I started poking around with creating a Stored Procedure this morning and I finally found the “you’re missing something insanely obvious” part of the equation.  All I needed to do to mix the aggregate function with a normal select was use the GROUP BY statement (which had the added bonus of also taking care of the need to use SELECT DISTINCT).

Long story short, I just reduced all of that code I posted yesterday to this.

<cfquery name=”getHitData” datasource=”#request.datasource#”>
    SELECT search_log.keywords, count(search_log.keywords) AS hitCount
    FROM search_log
    WHERE 1 = 1
    <cfif isDefined(‘attributes.startDate’) AND trim(attributes.startDate) is not ”>
        AND search_log.queryDate >= #createODBCDate(attributes.startDate)#
    </cfif>
    <cfif isDefined(‘attributes.endDate’) AND trim(attributes.endDate) is not ”>
        AND search_log.queryDate <= #createODBCDate(attributes.endDate)#
    </cfif>   
    GROUP BY search_log.keywords
    ORDER BY hitCount DESC
</cfquery>

And the page went from taking about 30 seconds to run to instantly loading.

Yay.

Coding/SQL question…

Ok, folks….This one is going out to all of you who work in SQL, cold fusion, etc…

I am currently working on series of reports based on keyword search data that we have archived from our main web site.  The page I’m working on is supposed to display the most popular keywords in descending order.  My initial thought was that I’d be able to get the data with one SQL query like so…

SELECT Count(search_log.keyword) AS hitCount, search_log.keyword
FROM search_log
WHERE search_log.keyword IN (SELECT DISTINCT search_log.keyword FROM search_log)

The problem is that once I throw COUNT in the mix SQL doesn’t seem to like returning any additional data from the table, so I had to break it down and find the results with cold fusion.  Doing so requires me to run a huge series of queries to get all of my data and the page takes forever to load.  Here’s what I’m doing…

<cfquery name=”getLog” datasource=”#request.datasource#”>
    SELECT DISTINCT (search_log.keywords)
    FROM search_log
</cfquery>

<cfset keywordCountArray = ArrayNew(1)>

<cfloop query=”getLog”>
    <cfquery name=”getCount” datasource=”#request.datasource#”>
        SELECT COUNT(search_log.keywords) AS hitCount
        FROM search_log
        WHERE search_log.keywords = ‘#getLog.keywords#’
    </cfquery>
    <cfset keywordCountArray[getLog.currentRow] = getCount.hitCount>
</cfloop>

<cfset newColumn = queryAddColumn(getLog, ‘hitCount’, ‘Integer’, keywordCountArray)>

<cfquery name=”getLogData” dbtype=”query”>
    SELECT getLog.keywords, getLog.hitCount
    FROM getLog
    ORDER BY getLog.hitCount DESC
</cfquery>

My thoughts on how to improve this…

I could just cache the “getLogData” query and not run the rest of them if the query exists, but I’m not sure if I can check for the existence of a cached query in ColdFusion.

Do the logic in a stored procedure.  Would speed things up slightly but, I think, still require me to run a multitude of queries.

Re-write the SQL in some terribly simplistic way that I’m just not seeing because I’m being blind.

Any help out there, gang?