XPS and me!

Back in the day, I loved working with XPS. In my opinion it was the greatest product Informix ever released – truly. And it is STILL being used by many clients…3 large sites in Phoenix, a few in Chicago, a few in Salt Lake City, and in Europe, XPS is still a favorite. (A German bank just paid for a new port to include the “multiple fragments in a single dbspace” feature from IDS…so yes, there WILL be another release).

Recently, I’ve had 3 XPS engagements in a row – what a treat. The tuning regimen is more similar now to IDS than back when XPS was first out – mostly due to the clients’ mixed workload of OLTP and DW. (XPS 8.31 first introduced features for mixed workload environemts.) So I find myself tuning “2 sides” – the OLTP side and the DW side, with some slight overlap depending on the site.

One peculiarity I’ve found with 2 XPS sites…an INCREDIBLE number of “Foreground Writes.” Can’t say that I expected that, but once I thought it through, it didn’t surprise me nearly as much. In the late 90’s when XPS was first cut loose, the memory footprint was much less in the boxes. So a great deal of the memory available was dedicated to the virtual portion in the engine, leaving less for the buffer cache in the resident portion. That seemed OK, since many of the queries were “long-running, read-only” guys that would do light scans. Light scans utilize light scan buffer in the virtual portion, so this was fine. But primarily you wanted a big memory footprint available for the PDQ environment and it’s “heavy-lifting” … sorting, grouping, aggregating, and the like. IF it could be done in memory, it’s faster than disk, of course. Plus, for a “typical” DW query, we’d notice “dynamic hash joins” would be the preferred join algorithm (with all due respect to the “push-down semi-join”). We like to put the hash table in memory if possible, so lots of memory available is good.

Advertisements

No Nuggets Over There!

Me and Xai were getting some late lunch, and as always, he’s eating his “fry-fries” exclusively, and ignoring his McNuggets. I asked him if he wanted ice cream after lunch, and of course, he said “yes.” With that, I said “no ice cream unless you eat your McNuggets though.” He looked across the room, and a girl was chomping down on an Oreo McFlurry. When Xai saw this, he said “SHE doesn’t have any McNuggets! [to eat]”, but papoo was quick…I said “She ate all of hers already!” (He was less than impressed, as he reached for another fry-fry….)

Singular Papoo – Not Plural!

Xai and I were swinging in my hammock out back when Hobo (the dog) stood up with ears and tail up. Xai said “what’s Hobo doin?”. I said “he’s listening to those other doggies barking.” Xai quickly corrected me – “it’s ONE doggie papoo, not TWO!”. I swing corrected.

Stinky Butt

My 24-yr. old son Scott loves kids and family. He’s about 6’4″ tall, and can’t get enough of the grandkids. He returned from “somewhere”, and my almost 3-year old grandson Xavier looked up at him as soon as he walked in the door and said “your butt stinks!” Scott said from that point he and Xai played together, and it made both of their days. 

I feel pretty, oh so pretty…

My almost 3-year old granddaughter, Ady, came into the house last weekend with my grandson, Xai, who is the same age. She stopped, stuck out her chest a bit and said “I’m pretty!” It was too funny…she at one point had said the same to Xavier, and he said “yeah yeah…I know….” (as if he’d heard it many, many times.) Kids…

Evel K-Xai-Xai

My almost 3-yr. old grandson is a daredevil…We were at the playground a few days ago, and he was climbing the ladder up to the tall slide, and of course, sliding down over and over. The platform for the top is about 6.5 feet tall or so…on one of his trips, he decided he didn’t want to slide down – he wanted to jump down. My heart dropped…he “thudded”…fortunately onto the shredded up rubber tires this playground has at the base. So the competition is on to see who gets to take Xai-xai to the hospital for broken bones first.

Weeeeeeeeee

Ady is coming up with all kinds of stuff. Was driving with her and just making idle “chit chat”…she said something “fun”, and I said “Wee doggie!!”. She quickly replied “Wee Kitty!!”…So we went down the road doing “sort of opposites” – like “Wee Sponge-Bob”, and she’d say “Wee Patrick”…

 

what fun..

The First Fish

After a few days of unpacking, getting a bit settled, and simple exhaustion from the Indiana heat, I decided it was time to test out the “fishin’ pond.” It was a bit low due to a shortage of rain, so I wasn’t sure how deep to fish. Actually – since I didn’t know the depth anyway, saying that “it was low” is just a convenient fisherman’s excuse. Tried some catfish bait, but the fish didn’t go for it. My dog, Hobo (I inherited him with the house, believe it or not) liked it, but I wasn’t quite sure it was good for him or not. Anyway, I decided to try a plastic worm, and some assorted depths. Nothing. Drug the jig across the pond slowly, and finally, got a strike. I didn’t even set the hook – didn’t have to…the fish planted the hook securely in it’s lip. Pliers had to be used to get the hook, and back in he went. I’d say he was between 1 and 2 lbs, and about 12-14 inches. So that’s the “first fish!” Oh…I texted a friend to report the “first fish”, and she asked “what kind was it?” I said, “…it was brown.” Since I haven’t fished since I was a boy, the memory is a bit “fishy…”. 

My almost 3-year old granddaughter, Ady, came into the house last weekend with my grandson, Xai, who is the same age. She stopped, stuck out her chest a bit and said “I’m pretty!” It was too funny…she at one point had said the same to Xavier, and he said “yeah yeah…I know….” (as if he’d heard it many, many times.) Kids…

My 24-yr. old son Scott loves kids and family. He’s about 6’4″ tall, and can’t get enough of the grandkids. He returned from “somewhere”, and my almost 3-year old grandson Xavier looked up at him as soon as he walked in the door and said “your butt stinks!” Scott said from that point he and Xai played together, and it made both of their days.