Tuesday, November 24, 2009

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)

Monday, November 23, 2009

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!

Sunday, November 22, 2009

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.

Saturday, November 21, 2009

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

Thursday, November 19, 2009

How to resizing image with convert (ImageMagick)

There are several ways to reduce the size of an image with 'convert'. I know one possible way that really works for me:

$ convert -size 768x512 in_file out_file

Wednesday, November 18, 2009

Nokia Messaging, latest edition, works like a charm

Get it at: http://email.nokia.com

Until earlier this year, Nokia Messaging still did not work (at least with my Nokia E71). It made me have to pay to:

  •  mail2web.com for a Microsoft Exchange email service
  • RoadSync, a M$ Exchange client for Symbian, as MailForExchange by Nokia consumes too much battery, can support not more than 400 emails in my INBOX and also allows me access to only my INBOX.

But just last week, I downloaded the latest version of Nokia Messaging and it just works! It can sync my gmail, all mail folders! And it consumes very small battery power! I can keep it always on for a full day and my battery decreases only 1 bar!!! I think Nokia must have changed the entire email for nokia development team heh

Right now, it's still free for use.

unsigned nerd