HOT TOYS - U.S.A.F. SECURITY FORCE IN IRAQ!

This is a new upcoming release from the good folks at Hot Toys. The close up shots are full of precise details for the utmost in authenticity. Be sure to read up on all your collectible toy news on the one site with tons of photos as well as videos. The one that started it all Action Figure Times. www.aftimes.com

Author: actionfiguretimes
Keywords: iraq hot toys actionfiguretimes aftimes.com air force security figure military darfur import
Added: April 3, 2008

"10,000 Days in Vietnam" Debut Trailer

The debut trailer for my upcoming epic, "10,000 Days in Vietnam," chronicling the views of American soldiers, Viet Kong soldiers, and the civilians caught in the middle of this civil war gone wrong.

Author: katvolver
Keywords: vietnam america vietkong laos northvietnam southvietnam france bombs usaf marinecorps wizart49
Added: April 2, 2008

YouTube Launches Living Legends

YouTube has launched a new monthly program called Living Legends that allows users to ask questions about featured celebrities.

read more

More...

Verizon Sees Long Term Evolution

Verizon said this morning the company will launch its next-generation wireless broadband network, dubbed Long Term Evolution (LTE) after sometime in 2010, approximately a year after the large swath of C-block 700 MHz spectrum the company won in a recent FCC auction becomes available.

read more

More...

Google Offers Overviews Of Olympic Torch Relay

To some people, the Summer Olympics are little more than a nuisance - their television viewing schedules get messed up, don'tcha know.  But those who really enjoy the Games may be glad for the chance to watch the 2008 Olympic Torch Relay in Google Maps and Google Earth.

read more

More...

Merchant 7588 - Jenson USA - Shimano XT Shifters, 37% off! Affiliate Marketing Deal

Merchant 7588 - Jenson USA - Shimano XT Shifters, 37% off! has teamed up with Shareasale to now offer a new deal for its affiliates! Deal marketing description:

Shifter set to replace or upgrade your existing set up 37% off!!

For more information or to become an affiliate / reseller for this merchant offering, or to promote this exclusive Shareasale deal, please visit:
Merchant 7588 - Jenson USA - Shimano XT Shifters, 37% off!'s Affiliate Deals page...

Multi-Column IN clause - Unexpected MySQL Issue

We have an application which stores massive amount of urls. To save on indexes instead of using URL we index CRC32 of the URL which allows to find matching urls quickly. There is a bit of chance there would be some false positives but these are filtered out after reading the data so it works all pretty well.
If we just process urls one by one it works great:
PLAIN TEXT
SQL:

1. [FONT='Courier New', Courier, monospace]mysql> EXPLAIN SELECT url FROM 124pages.124pages WHERE url_crc=484036220 AND url="http://www.dell.com/";[/font]
2. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+[/font]
3. [FONT='Courier New', Courier, monospace]| id | select_type | TABLE | type | possible_keys | KEY | key_len | ref | rows | Extra |[/font]
4. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+[/font]
5. [FONT='Courier New', Courier, monospace]| 1 | SIMPLE | 124pages | ref | url_crc | url_crc | 4 | const | 1 | USING WHERE |[/font]
6. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+[/font]
7. [FONT='Courier New', Courier, monospace]1 row IN SET (0.02 sec) [/font]

Handling URLs one by one is however not efficient if you're processing millions of them so we tried to do bulk fetches:
PLAIN TEXT
SQL:

1. [FONT='Courier New', Courier, monospace]mysql> EXPLAIN SELECT url FROM 106pages.106pages WHERE (url_crc, url) IN ((2752937066, 'http://members.aye.net/~gharris/blog/'), (3799762538, 'http://www.coxandforkum.com/'));[/font]
2. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+------+---------+------+-------+-------------+[/font]
3. [FONT='Courier New', Courier, monospace]| id | select_type | TABLE | type | possible_keys | KEY | key_len | ref | rows | Extra |[/font]
4. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+------+---------+------+-------+-------------+[/font]
5. [FONT='Courier New', Courier, monospace]| 1 | SIMPLE | 106pages | ALL | NULL | NULL | NULL | NULL | 14936 | USING WHERE |[/font]
6. [FONT='Courier New', Courier, monospace]+----+-------------+----------+------+---------------+------+---------+------+-------+-------------+[/font]
7. [FONT='Courier New', Courier, monospace]1 row IN SET (0.00 sec) [/font]

As you can see just using multiple column IN makes MySQL to pick doing full table scan in this case, even though the cardinality on the first column is almost perfect. I did some more testing and it looks like a bug or missing optimizer feature.
I should not be surprised though as multi-column in is not the most used MySQL feature out there.
For given application case we could simply rewrite query using more standard single column IN clause:
PLAIN TEXT
SQL:

1. [FONT='Courier New', Courier, monospace]mysql> EXPLAIN SELECT url FROM 106pages.106pages WHERE url_crc IN (2752937066,3799762538) AND url IN('http://members.aye.net/~gharris/blog/','http://www.coxandforkum.com/'); +----+-------------+----------+-------+---------------+---------+---------+------+------+-------------+[/font]
2. [FONT='Courier New', Courier, monospace]| id | select_type | TABLE | type | possible_keys | KEY | key_len | ref | rows | Extra |[/font]
3. [FONT='Courier New', Courier, monospace]+----+-------------+----------+-------+---------------+---------+---------+------+------+-------------+[/font]
4. [FONT='Courier New', Courier, monospace]| 1 | SIMPLE | 106pages | range | url_crc | url_crc | 4 | NULL | 2 | USING WHERE |[/font]
5. [FONT='Courier New', Courier, monospace]+----+-------------+----------+-------+---------------+---------+---------+------+------+-------------+[/font]
6. [FONT='Courier New', Courier, monospace]1 row IN SET (0.01 sec) [/font]

Theoretically speaking this query is not equivalent to the first one - because row having url_crc=2752937066 and url='http://www.coxandforkum.com/' would match it, while it should not. It however does not happen in our case as url_crc is functionally dependent on url so both queries are equivalent.
So we've got our work around and can forget about the issue and MySQL team gets yet another bug to deal with.
What worries me again is - this is very simple case which seems to to be generally broken which raises a question how good coverage MySQL tests have.
Entry posted by peter | No comment
Add to: | | | |


Multi-Column IN clause - Unexpected MySQL Issue - Read More...

Ten Comments on Housing (pfblogs.org)

David Merkel submits: 1) The big question is how much further will housing prices fall, and when will the turn come. My guess is 2010 for the bottom, and a further compression of prices of 15% on average. Now there are views more pessimistic than that, but I can't imagine that a 50% decline from the peak would not result in a depression-type scenario. (In that article, the UCLA projections are largely consistent with my views.) It is possible that we could overshoot to the downside. Markets do overshoot. At some level though, foreigners will find U.S. housing attractive as vacation/flight homes. After all, with the declining dollar, it is even cheaper to them. Businesses will buy up homes as rentals, only to sell them late, during the next boom. 2) But, the reconciliation process goes on, and with it, losses have to go somewhere. In some cases, the banks in foreclosure refuse to take the title. Wow, I guess the municipality auctions it off in that case, but I could be wrong. Or, they let the non-paying borrowers stay. I guess the banks do triage, and decide what offers the most value to act on first, given constraints in the courts, and constraints in their own resources. ...

Coming Up on the D4L Channel (pfblogs.org)

This chemical can be deadly. It will take the skin off your bones, was used during World War I as a pulmonary choking agent and it is used to make pesticides. Oh by the way, this chemical is in my home and it is probably in yours. But the question at hand is, can its manufacturer find its way into my dividend portfolio? Stay tuned, we'll find out...Now a word from our sponsor: The Ronco portfolio whopper-chopper slices and dices your portfolio into, not one, not two, but three unique views. You have your traditional capitalization slice, contemporary origin slice and, for no additional charge, we are throwing in a sector slice. All of this is available for the low, low price of free next week only.It's going to be a memorable week. Don't risk missing a minute of it. You can have it all packaged and delivered directly to you free by clicking here and subscribing to the D4L Channel.While waiting for this week's feature presentations, you may want to tune in to a few of these classic episodes:My Unique Investing ProcessPre-Screening Dividend Stocks - Part I Sometimes Things Aren't As They ...