 |
Guitar & Pen |
|
||||||||||||||||||||||||||
| Info | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
|
|
|
|
||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
Thoughts on just about everything from rock-n-roll, sports, kids, to geek speak -- by John Bullock About John Subscribe to this blog  |
|
||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
| Archives | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
|
|
|
|
||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 September 2007 November 2007 December 2007 January 2008 February 2008 |
|
||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
| Links | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
|
|
|
|
||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
Friday, May 28, 2004 |
|
||
|
||
|
I was asked to troubleshoot a performance problem at work and found that the root of the problem was self inflicted. I want to publicize the solution so that hopefully somebody will learn from the mistake that this developer made which seems innocent enough on the surface but if you think about it, you understand why it kills performance and make sure that nobody ever does it again (yeah, right). Take the following query:
SELECT a.field1, a.field2, a.field3, b.field1 FROM a LEFT OUTER JOIN b ON CAST(b.somefield as varchar(26)) = a.anotherfield WHERE a.key = @MySearchCriteria Seem simple enough? Can you see the issue? It is the CAST statement. When you a processing a significant amount of data you are forcing the data conversion on every single row in table b forcing a table scan in addition to putting a cognizant workload on your DB server by having to convert all of these values. Add two performance problems together and you get an even bigger performance problem. Although this cast/covnersion was explicit in the stored procedure, it is not always the case. Sometimes the fields are of different types on their is not explicit conversion, but it is still happening. Moral of the story, is to make sure you keep your data types consisent throughout your database and queries to avoid casting and converting. |
|
|
||
|
|
||
|
||
|
I've been working with one of the developers at my company designing a new Real Time Trade Matching (RTTM) system. One of the challenges we face is being able to do asynchronous message processing but preserving message order for the multiple messages per trade that we will receive. I discussed the issue with another CSS architect and he had a solution (as he was just addressing the same issue during the design of a new message switch). However, as I was working through it, I discovered flaws so after having over an hour long discussion with the four of us, we finally came up with a solution. However, it is not one that I am wild about so I would love to hear about other soltuions and/or patterns that fit this so I can see if they will work any better.
Just to give a little more detail, basically we will be receiving multiple status messages per trade. And for a single trade, we must process these messages in order. So although I can process messages for different trades simultaneously, we cannot process messages for a single trade at the same time. |
|
|
||
|
|
|
Thursday, May 27, 2004 |
|
||
|
||
|
I have absolutely no sympathy for this guy. Has he been living in a cave and not heard all the controversy about the Atkins diet? We have known for a long time that you should eat a diet low in fat to prevent heart disease. What an idiot!
BBC NEWS | Health | Atkins dieter sues after heart op |
|
|
||
|
|
||
|
||
|
My cousin Vinny (Castilla) hit #13 & #14 yesterday to lead the league in HR's! Way to go Vinny!!! I am so glad we got him back (not just because I got his jersey right before the Rockheads traded him last time). Just too bad the Rockies will suck for forever and a day! | |
|
||
|
|
||
|
||
|
I went riding last night and finally got to the year's first century mark. I realize this isn't much for (hardcore) roadies who do this in a single day, but I would love to take them on a single 6 mile mountain bike ride and see how well they do. There is no comparison between the effort needed to climb up a steep singletrack covered with loose rocks and debris. | |
|
||
|
Wednesday, May 26, 2004 |
|
||
|
||
|
No wonder I never get food poisoning or sick to my stomach...
Reuters Health Information (2004-05-26): Salsa spice fights bacteria, study finds |
|
|
||
|
Tuesday, May 25, 2004 |
|
||
|
||
|
I want to give kudos and thanks to the support folks at both FeedBurner.com and Blogger.com for helping me get my archiving and RSS feed working properly so that folks using RSS news readers and such can consume my log with them rather than visiting the log daily. Also got the issue resolved where the source was incorrect if you tried to follow the link located in the RSS feed. Well done!!!
Next up is to get comments working so I can hear what everybody (????) thinks about my thoughts. Back to work now! |
|
|
||
|
Monday, May 24, 2004 |
|
Thursday, May 20, 2004 |
|
Wednesday, May 19, 2004 |
|
||
|
||
|
In the CD player is The Who's Thirty Years of Maximum R&B (Disc One). | |
|
||
|
|
||
|
||
|
It doesn't matter if you like the player or the team, whenever a pitcher throws a perfect game, you have to be awestruck. Kudos to Johnson!
Yahoo! News - Randy Johnson Hailed as 'Pitcher Perfect' |
|
|
||
|
Friday, May 14, 2004 |
|
||
|
||
|
Excellent news about a new Tom Petty album. I just happen to have Tom Petty's Into the Great Wide Open in my CD player currently.
Yahoo! News - Tom Petty Gets Busy on New Album, Live Set |
|
|
||
|
Tuesday, May 11, 2004 |
|
||
|
||
|
Shame on you parents!!! I never let me kid on a bike without a helmet. How about you?
Reuters Health Information (2004-05-11): Survey: U.S. children not wearing bike helmets |
|
|
||
|
Monday, May 10, 2004 |
|
|
||
|
||
|
In the CD player currently is Bruce Springsteen's Greetings From Asbury Park, N.J. | |
|
||
|
Thursday, May 06, 2004 |
|
||
|
||
|
This is a really cool thing. Although I use VS .Net at work, I could see the cheap part of me going with something like this at home. I guess I will need to try it out!
#develop Beta 1 release available |
|
|
||
|
Tuesday, May 04, 2004 |
|
||
|
||
|
Can't they just decide what is healthy so we can all get on with living???
Reuters Health Information (2004-05-04): Low-fat may not be best for heart: study |
|
|
||
|
|
||
|
||
|
I haven't posted much lately as I've been buried. I got a new desktop machine Wednesday afternoon, and my laptop died Wednesday night. Unfortunately there was stuff I had not backed up that I'm still missing. Originally they thought the hard drive was fried, but it may have just been the cable they were using. Let's hope so! In the mean time, I got one of loaner laptops so I can be mobile and work in front of the TV. | |
|
||
|
|
||
|
||
|
It's official; I've had my first bicycling accident of the year. Nothing to bad, just a little road rash. We'll see how I feel tomorrow but good ol' Ibuprofen is doing it's thing well right now! BTW, today was the first day that I was brave enough to try anything with climbing. Let's just say a I was slow and very out of practice. | |
|
||