One of my applications ran slow. On detail page, about 300 records are returned from DB and shown on the page, it however took about 5 seconds to render the whole page. How to find out what’s going on behind,
Codeigniter email message – characters replaced with equal signs
When using CodeIgniter Email class, I have some characters replaced by equal signs (=) . To avoid this use below code: $config = array ( ‘mailtype’ => ‘html’, ‘charset’ => ‘utf-8’, ‘crlf’ => “rn”, //Notice double quote to enclose rn ‘priority’
Microstrategy metric
I have to admit I’m not a fan of Microstrategy, the main reason is its rich features are buried in various places at the corner of tiny configuration items. For example I created a metric using CaseV CaseV(mtrFYear, 2013, 16.33,
Jasper report server
I was developing a telecommunication bill using Jasper Studio (V6.0.4) on Windows and Jasper Server (V6.0.1) which was remotely hosted on an Ubuntu server. Jasper Studio was used to design layout while Jasper Server was in charge of generating final
Postgresql debugger
It took me a while to figure out how to enable debugger for Postgresql server on Ubuntu. Initially I thought it was pre-packaged by Ubuntu therefore apt-get installed a few packages such as pgadmin3, pgadmin3-dev, postgresql-version.dbg. Here is a post
PHP debugging
I recently came cross debugging in PHP. I know from my own experience that a lot of people are still using echo/print, var_dump to debug code. Nothing wrong but sometimes when you scratch you head wondering what’s inside that tiny
Building a web site using PHP on IIS/SQL server using Windows authentication.
PHP+IIS, although not a popular combination, it may be the easiest solution in a corporate departmental environment, which is largely Windows based. PHP programming won’t be discussed here, rather I’d discuss how Windows authentication is achieved. The beautify of Windows
SQL server computed field
I recently came across this very interesting rounding issue in MS SQL server. Originally I thought in order to keep computation in highest accuracy possible, I should use the max allowed precision, i.e. on SQL server a decimal(38,18). However after definition of
ACL 10.5 new features
I recently upgraded my ACL ( a data analysis tool widely used by IT auditors) to 10.5 and noticed there are a number of new functions introduced. EOMONTH( ): Returns the date of the last day of the month that
dropdown list using AJAX and Laravel
On my website, I want to display a drop-down list of cars, from which once the item(car) is chosen, the corresponding car’s price is retrieved from DB. The challenges are: 1. car price is just part of the screen 2. car price