Impossible Problem? Take Baby Steps

Once a year in February, we process the first motor vehicle “commitment” (bill) for the calendar year. This year, there were 29,161 new excise bills. More bill runsĀ  follow as a result of additional commitments, as people sell and buy cars and/or move in and out-of-town, but this first excise bill run it is the biggest of the year, and all new excise bills’ addresses are run through address verification software, so, if validated, the address can be bar-coded. Bar coding mail saves a lot of money.

I have wanted to speed up the original process, and felt that could happen. It was going to take several steps, the first of which was to modify the software to use a faster routine. After making the software changes, a strange error popped up. http://drknucklehead.wordpress.com/2011/07/06/strange-informix-error/

It was completely depressing. Informix Support translated the error, which made no sense in the context of my program — Informix Support is always very good, by the way — and so I put this project off until this week.

Today, I broke the problem up into steps. This led me to a completely different problem involving database table indexes. There is a workaround for this problem, and that is a good thing.

Advertisements

Leave a comment

Filed under Musings

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s