Eric Guo's blog.cloud-mes.com

Hoping writing JS, Ruby & Rails and Go article, but fallback to DevOps note

Firefox13 Is Now Four Times Faster Than IE9

Permalink

http://ie.microsoft.com/testdrive/Performance/SpeedReading/Default.html

Browser Score Window Size Test Date
IE 9.0.8112.16421CO 22 seconds 1858x1024 8/21/2011
Firefox 6.0 23 seconds 1858x1016 8/21/2011
IE 9.0.8112.16421CO 40 seconds 1920x1080 1/29/2012
Firefox 9.0.1 20 seconds 1920x1079 1/29/2012
Firefox 10.0.1 17 seconds 1920x1062 1/29/2012
Firefox 13.0 9 seconds 1920x1062 6/6/2012
Safari 15.3 6 seconds 1728x1028 2/2/2022
Chrome 98.0 6 seconds 1728x1028 2/2/2022

Conclusion:  IE 9 maybe a little faster, but consider the Firefox more memory footprint saving and cross-platform and so many extension and plug-in. I still prefer Firefox as my primarily browser. (only right at 8/21/2011)

Conclusion:  Firefox13 is now four times faster than IE9!

A True Story About Upgrade Crystal Report From Oracle 9i to Oracle 11gR2

Permalink

Few months ago, my company decides and proceeds to upgrade our factory MES system, we create a new database for the new MES system, using Oracle 11gR2 instead of previous Oracle 9i, and we also create a new user and its schema meswip45 instead of previous mesprd on the new 11g database.

Every program which link to the MES system was upgrade side by side, one after another according to the project plan, it is barely smoothly according to the plan. Now, we will make MES system go live to the production in 2012/1/2 and it's the best time point as it is most idle time in a year and just following by Christmas and Chinese Spring Festival.

But during last two weeks UAT, one of our user found the Travel Card (just the Crystal Reporting business alternative name, you can read it as a specially report) cannot output via printer, after check the one of the slowest Crystal Reporting, we can easily conclude that there is no program logic bug to block the Crystal Travel Card printing. It is just the reporting execution time is unreasonable long (more than 2 minutes to output the actual content).

Solve ORA-02049: Timeout: Distributed Transaction Waiting for Lock

Permalink

In Oct 28 2011, while I was working to recover a production reporting oracle database sync SQL facility provide by MES vendor Camstar, I meet the ORA-02049 error, Such error is never observed, but after kill session relative with sync SQL in production transaction database, the whole sync SQL facility return to normal.

So except the reason suggested by the Burleson Consulting, the root cause in my case can be the reporting server suddenly down and in it’s 2 phase commit, there is exist a lock in transaction database but rebooted reporting server’s oracle now can not known it. so after kill that pending session, the ORA-02049 error disappeared.

Suddenly UNIX server reboot/memory dump is still possible, so I record here and hoping its useful for you.

Official Firefox Download and Some Add-on I Use

Permalink

I perfer use the official Firefox (Not the China Zhimei .CN version) and here is the Add-on I install:

Add-on Name Description
Adblock Plus Block all ads automatically
AutoProxy Smart proxy management (No used now as I only use VPN)
BaiduSearch Some time need...
EPubReader Read EPUB files just in Firefox
Fiddler Http Debugging Tools
Firebug Web Development
HTML5 Notifications Add desktop notifications to Firefox
Rapportive Rapportive adds rich contact profiles to Gmail.
RESTClient RESTClient, a debugger for RESTful web services.
Vimperator Vim keyboard mode for Firefox
Scriptish user javascript manager (better than Greasemonkey)
SQLite Manager Manage and SQLite database on your computer
Weibo Kong Sina Weibo messenger

Running Knoppix 6.7.1 in a Sandisk Ultra Flash Drive to Do GAE Programming via PyCharm

Permalink

A couple of days ago, I just re-install Windows 7 on IBM X60 based on the flash drive, now the new bought Sandisk Ultra USB flash drive is no use now, so during the National Holiday, I just install a Live-CD type Linux on it so I can play something different with MS stuff latter.

I choose Knoppix largely because of it's size: Knoppix has the largest size among other Linux distribution like puppy/Slax as well as it's popularity, you can Get Knoppix via a BT client like µTorrent. After you get the 3.68GB DVD ISO downloaded, the step to custom Knoppix to fit your needs will be quite simple (yes simple, but it must be consider in the Linux standard):

Fast Fill Huge Number of Same Value to Below Cells in Excel

Permalink

Many people know when drag the small black square in the lower right-hand corner of the cell in Excel, Excel will auto fill the value, fewer people know drag the small black square in right mouse-key will pop-up the context menu and let you select Copy Cells, Fill Series, or other options like below picture: