Mugen Power Battery 3600mAh

Around 1230AM, Wednesday, I still had 1 bar left.

I decided to recharge the battery then because I had to go to bed and I was afraid that I wouldn't have enough battery for tomorrow which will be a long day.

In total, starting at 3PM on Saturday, the new battery lasted for 3days + 9 hours == 81 hours with always on email all the time, facebook, phone calls, sms, voip, bluetooth and etc (normal usage)

DBD::Oracle Perl Module returning data via refcursor bug - I have found a work around

DBD::Oracle Perl module, even with its latest version, still has a bug when we return data from Oracle to Perl via a refcursor. The problem is that it will be very slow because the driver does not perform the caching when fetching data from refcursor.

It will be very fast if the data are fetched through SQL SELECT statement, however.

I have found a workaround that you can apply it to your existing codes without having to modify your existing logics.

The workaround is to use Oracle's Global Temporary Table (GTT). And, inside your stored procedure, instead of fetching data into a refcursor, you change the code to fetch into your GTT instead. Then, in your Perl code, you modify the code so that it fetches the data from SQL SELECT statement. This way, you can fetch large data at a very fast speed.

GTT has a behavior that the data inside it are private for each different database transaction and will be emptied once your transaction ends or you force it to do so.

Woo Hoo!

Mugen Power Battery 3600mAh

at 0900PM, Sunday, November 22, 2009

4 bars left.

This is faster than I expected. I thought decreasing from 5 bars to 4 bars should have occurred at 3AM, Monday.

Mugen Power Battery 3600mAh

Sunday, November 22, 2009 at 0655PM

Battery has 5 bars left.

Mugen Power Battery 3600mAp

12 hours has just passed. 1 bar is used.

I used pushed email all day, facebook all day, transferring file via bluetooth, sms and some phone calls.

So far so good!

Mugen Power Battery 3600mAh for Nokia E71

November 21, 2009, at 0300PM ICT

The first full 12 hours of charging. Now, I start using it for the first time. I will wait to see how long can it last with:

- some phone calls
- many sending/receiving sms
- many sending/receiving emails via Nokia Messaging
- some sending/receiving emails via MailForExchange
- and some other stuff

Mungen Power battery for Nokia E71

November 21, 2009, 0300PM ICT