Author Archives: ayn

any mysql experts out there?

One of my e-commerce clients has been experiencing extremely long delay in the credit card processing step of the checkout process, I’ve look into this and narrowed it down to the following line of code:

$paypalipn_query = tep_db_query(“select o.orders_status,p.* from ” . TABLE_ORDERS . ” o LEFT JOIN ” . TABLE_PAYPALIPN_TXN . ” p on p.item_number = o.orders_id AND o.customers_id = ‘” . (int)$customer_id . “‘ order by o.date_purchased desc limit 1”);

I’ve disabled PayPal IPN and commented out that line so checkouts are speedy and quick now. But I have no idea why this single line of mysql query takes about a minute and a half to return. I suspect the table is messed up, the orders table (TABLE_ORDERS) is probably okay coz the rest of the site uses that table a lot, so maybe the paypalipn_txn table is messed up, but I have no idea what to look for or how to fix it… It really isn’t very large… If you have an idea of what’s messed up, please leave a comment… πŸ™‚

Technorati Tags:

very impressive, apple just shipped my blue nano

When they said “ship within 24 hours” they actually meant it at the Apple online store, very nice… I should have it maybe even by this weekend and I’ll have a week to gift wrap it… I should’ve engraved it… πŸ˜†

btw, I was watching the news channels this morning and they got REALLY confused about shuffle vs nano vs big ipod, I like how they were referring to blogs as their source of information… the “hits” feeding off the “tail”, very interesting…

Technorati Tags: , ,

new iPods, iTunes, and iTV dropped

Looks like I’ll be buying a few more iPods, maybe one of those new Shuffles for workout, I might sell the 60gb for the 80gb, but what I really need is a 100gb. I’ve already ordered a blue 4gb aluminum Nano as a gift. (well I also want to see how it looks like first hand, lol)
The iTV thing is definitely cool, I think of it as a Airport Express with Video, I wonder if it would work as a WiFi access point like the Airport Express.

Now, I wonder who’s audio and wifi chips they use on these new stuff…

iPod shuffle. Holds music. 1GB. $79.iPod nano. Holds music and photos. 2GB, 4GB, 8GB. From $149

iPod. Holds music, photos, and video. 30GB, 80GB. From $249

Blogged with Flock

$16B for FSL?

Freescale Semiconductor confirmed Monday it is in discussions that could lead to a record $16-billion leveraged buyout, sending shares surging $5.93, or up more than 19 percent, to $36.68 in midday trading Monday.

Two sets of bidders are vying for ownership of the Austin, Texas-based chip maker in what would mark the largest high-tech leveraged buyout ever and one of the largest buyouts ever.

RED HERRING | Firms Bid $16B for Freescale

technorati tags:, , ,

Blogged with Flock

2007 MCS, 192lbs lighter!

Oh yeah, I like it! We didn’t get the stupid moonroof to save the 90lbs, now the base model is 192lbs lighter! that’s awesome! Me likes!! I like the new door panels too, not sure what color to get now though.

2007 Mini Cooper, Cooper S (Mk II - R56) unveiled

2007 Mini Cooper, Cooper S (Mk II - R56) unveiled

BMW has released official images of the 2007 Mini Cooper (Mk II aka R56). As previously reported, the car will be offered in Mini Cooper (120 horsepower) and Cooper S (175 horsepower) guise. Both cars are powered by a 1.6 liter four-cylinder engine. The Mini Cooper reaches its peak 120 horsepower output at 6,000 rpm and peak torque of 118 lb-ft at 4,250 rpm. It features Valvetronic technology for an added edge over the previous model. The turbocharged Cooper S makes 175 horsepower at 5,500 rpm, and peak torque of 177 lb-ft comes at just 1,600 rpm. While the 2.76-inch-longer exterior is mostly evolutionary, BMW describes the new interior as “revolutionary.” For increased safety, curtain airbags now protect all passengers. Despite the car’s increased measurements, its weight has been reduced by 192 lbs for the Cooper S manual, 72 lbs for the Cooper S auto, 181 lbs for the Cooper manual, and 49 lbs for the Cooper auto.

2007 Mini Cooper, Cooper S (Mk II – R56) unveiled | Leftlane News – Car News For Enthusiasts

technorati tags:, ,

Blogged with Flock

Sherry’s Speedy Reduced

Copped this from my AD, just came in today. It’s got the Dubois-Depraz “piggyback” movement, which is pretty much an ETA watch with the chronograph function on it. Since it’s like 2 movements it’s highly jeweled. πŸ™‚ Most chronoheads don’t dig this movement but it is probably more reliable than the Piguet-based c.33xx or the c.3603 in my BA GMT. πŸ™‚ It’s a great deal I think for such a great looking lady chronograph.

I didn’t know the ladies’ Omega’s come in such nice packaging!!

technorati tags:, , , , , , , ,

Blogged with Flock

My Treo 700p is stuck in a reset loop

Tried everything including a hard reset, nothing helped, so Verizon is sending me a replacement, had to pay twelve bucks to have it overnight to make sure I’ll have a freakin phone this weekend… πŸ™‚ Didn’t think it would be this hard to live without EvDO until I don’t have it. πŸ˜‰

After some digging poster at TreoCentral and MyTreo said a batch of 700p had “bad memory chips”, I can’t verify how true that is, but whatever… I just want my 700p replacement asap and hopefully I can set the HotSync ID to the same and just do a restore and get everything back.

Here’s a video of the reset loop:

Technorati Tags: , , ,