Wednesday, September 4, 2013

OBIEE 11g: User Interface (UI) Performance Tuning / Enhancement

2.6.4 Apache 2.2.x HTTP Server
This topic describes how to enable caching and compression in Apache HTTP Server of your Oracle® Business Intelligence Enterprise Edition. Important Note: High load of HTTP replies with 304 status code causes the OBIEE 11g UI to work slow in IE browser 7 / 8. To resolve this issue, it is highly recommended to implement HTTP caching and compression that will help to minimize the round trips over the Web to
revalidate cached items, can make a huge difference in browser page load times.
a. How to Enable Compression and Caching:

1. On the Apache machine, open the file HTTP Server configuration file (httpd.conf) for editing.
2. In httpd.conf file, verify that the following directives are included and not commented out:
LoadModule deflate_module modules/mod_deflate.so
LoadModule expires_module modules/mod_expires.so
LoadModule headers_module modules/mod_headers.so

3. Add the following lines in httpd.conf file below the directive LoadModule section to compression / caching and restart the Apache HTTP Server: 

#HTTP Compression
<IfModule mod_deflate.c>
SetOutputFilter DEFLATE
SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.(?:exe|t?gz|zip|bz2|sit|rar)$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.(?:pdf|doc?x|ppt?x|xls?x)$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.avi$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.mov$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.mp3$ no-gzip dont-vary
SetEnvIfNoCase Request_URI \.mp4$ no-gzip dont-vary
</IfModule>

#Caching of static files
ExpiresActive On
<IfModule mod_expires.c>
ExpiresByType image/gif "access plus 3 months"
ExpiresByType image/jpeg "access plus 3 months"
ExpiresByType application/x-javascript "access plus 3 months"
ExpiresByType text/css "access plus 3 months"
ExpiresByType text/javascript "access plus 3 months"
ExpiresByType image/png "access plus 3 months"
ExpiresByType application/x-shockwave-flash "access plus 3 months"
</IfModule>

#This stops the HTTP 304 replies in IE 7/8 browser
<IfModule mod_headers.c>
<FilesMatch "\.(gif|jpeg|png|x-javascript|javascript|css|swf)quot;>
Header set Cache-Control "max-age=7889231"
</FilesMatch>
</IfModule>

Source

Hope this helped!