I solved the problem of multiple execution during the JSF lifecycle\u00a0 by checking if the request has already actual data\u00a0(details can be found here<\/a> – German only), but there was still a problem: Everytime a XPage wants some data to display, a query is sent to the domino server. This is nice if your application requires data in real-time, but not for a normal application – it kills the user experience.<\/p>\n This is why I searched a way which easily allows to implement memory cached database queries for domino databases.\u00a0 The main idea is that the database query is no longer send directly to the backend . Instead, the request is made against a JSON wrapper, and the request to this wrapper (an agent residing in the same NSF) is done via a proxy. This allows a full control of the requested data.<\/p>\n The browser sends the HTTP request to the XPage and receives the response. The XPage queries the MemCache for data; if the data is not in the cache, the proxy queries the data storage (the domino database) and caches the result. The XPage has to parse the JSON data only, and this boosts the performance in my test environment for about 250-300%.<\/p>\n By „stealing“ the session cookie, the database query to the backend database will be done in the context of the user; the security for domino databases is not influenced.<\/p>\n In my solution, I am using Apache 2.2 as reverse proxy. The following modules are additionally enabled for this solution:<\/p>\n The virtual host configuration looks like this:<\/p>\n As you can see, the proxy runs on port 8080, and I have added a special content type „domino\/json<\/em>„. This makes it easier to identify the relevant data.<\/p>\n This is the XPage the user accesses:<\/p>\n The Java class used is really simple, I know there are better ways to do a Http request, but this is a proof of concept.<\/p>\n And here comes the JSON handler, a simple Lotus Script agent:<\/p>\n In the next days I will provide a sample database and add more details. A database with 300k test datasets will be added too.<\/p>\n","protected":false},"excerpt":{"rendered":" During the last months I worked on a high performance XPages application used by a lot of end users.\u00a0 To get a better data throughput, I decided to use a reverse proxy for load balancing, caching of ressources, SSL connections … Weiterlesen <\/p>\n
\n
<VirtualHost *:8080>\r\n\u00a0ServerName localhost\r\n\r\n\u00a0# Enable reverseproxy\r\n\u00a0ProxyRequests Off\r\n\u00a0ProxyPreserveHost On\r\n\u00a0<Proxy *>\r\n\u00a0 AddDefaultCharset off\r\n\u00a0 Order allow,deny\r\n\u00a0 Allow from all\r\n\u00a0<\/Proxy>\r\n\r\n\u00a0# Proxy config for Domino server\r\n\u00a0# \r\n\u00a0ProxyPass \/ http:\/\/localhost:80\/\r\n\u00a0ProxyPassReverse \/ http:\/\/localhost:80\/\r\n\r\n\u00a0 # prevent max-age calculation from Last-Modified\r\n\u00a0 # prevent If-Modified-Since requests\r\n\u00a0 # reduces the number of requests that hit the server\r\n\u00a0<LocationMatch \"\/.*$\">\r\n\u00a0 Header unset Last-Modified\r\n\u00a0 Header unset ETag\r\n\u00a0 Header unset HTTP_CACHE_CONTROL\r\n\u00a0<\/LocationMatch>\r\n\r\n\u00a0# MemCache Config\r\n\u00a0# \r\n\u00a0CacheEnable mem \/\r\n\u00a0CacheEnable mem http:\/\/\r\n\r\n\u00a0# Cache-Size 80 MB\r\n\u00a0MCacheSize 81920\r\n\u00a0MCacheMaxObjectCount 8192\r\n\r\n\u00a0# Min Obj. Size 1 Byte\r\n\u00a0MCacheMinObjectSize 1\r\n\r\n\u00a0# Max Obj. Size 1 MB\r\n\u00a0MCacheMaxObjectSize 1000000\r\n\r\n\u00a0# cache for 60 seconds by default\r\n\u00a0CacheDefaultExpire 60\r\n\r\n\u00a0# FORCE caching for all documents (without Cache-Control: no-cache)\r\n\u00a0CacheIgnoreNoLastMod On\r\n\r\n\u00a0# force caching for all requests\r\n\u00a0# ignore client side Cache-Control header\r\n\u00a0CacheIgnoreCacheControl On\r\n\u00a0# don't add Set-Cookie header to cache\r\n\u00a0CacheIgnoreHeaders Set-Cookie\r\n\r\n\u00a0# Add expires headers for images, css & js files\r\n\u00a0# reduces the number of requests that hit the server\r\n\u00a0ExpiresActive On\r\n\u00a0ExpiresByType domino\/json A600\r\n\r\n<\/VirtualHost><\/pre>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<xp:view xmlns:xp=\"http:\/\/www.ibm.com\/xsp\/core\"\r\n xmlns:xc=\"http:\/\/www.ibm.com\/xsp\/custom\">\r\n\r\n\u00a0\u00a0 \u00a0<xp:pager layout=\"Previous Group Next\" partialRefresh=\"true\"\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0id=\"pager1\" for=\"repeat1\">\r\n\u00a0\u00a0 \u00a0<\/xp:pager>\r\n\r\n\u00a0\u00a0 \u00a0<xp:inputText id=\"inputSearch\" value=\"#{sessionScope.searchFor}\" \/>\r\n\r\n\u00a0\u00a0 \u00a0<xp:button value=\"Label\" id=\"button1\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:eventHandler event=\"onclick\" submit=\"true\"\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0refreshMode=\"complete\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:eventHandler>\r\n\u00a0\u00a0 \u00a0<\/xp:button>\r\n\r\n\u00a0\u00a0 \u00a0<xp:repeat id=\"repeat1\" rows=\"30\" var=\"rowData\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:this.value><![CDATA[#{javascript:\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0importPackage( ch.hasselba.xpages.util );\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var sessionId = null;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0try{\r\n\u00a0\u00a0 \u00a0 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0sessionId = cookie.get(\"DomAuthSessId\").getValue();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}catch(e){}\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var url = \"http:\/\/localhost:8080\/Data.nsf\/DoSearch?OpenAgent\";\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0url += \"&sessionId=\" + sessionId;\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if( sessionScope.get(\"searchFor\") !== null ){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if( sessionScope.get(\"searchFor\") !== \"\" )\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0url += \"&search=\"; \r\n url += java.net.URLEncoder.encode(sessionScope.get(\"searchFor\"),\"UTF-8\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var data = ch.hasselba.xpages.util.URLReader.read( url, sessionId );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var parsed = null;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0try{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0parsed = fromJson(data).data;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}catch(e){}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0parsed\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}]]>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:this.value>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:text escape=\"true\" id=\"computedField1\" value=\"#{javascript:rowData.LastName}\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:text>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:text escape=\"true\" id=\"computedField2\" value=\"#{javascript:rowData.FirstName}\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:text>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:br \/>\r\n\u00a0\u00a0 \u00a0<\/xp:repeat>\r\n\r\n<\/xp:view><\/pre>\npackage ch.hasselba.xpages.util;\r\n\r\nimport java.io.BufferedReader;\r\nimport java.io.InputStreamReader;\r\nimport java.net.URL;\r\nimport java.net.URLConnection;\r\n\r\n\/**\r\n\u00a0* URLReader\r\n\u00a0* performs a HTTP request\r\n\u00a0* \r\n\u00a0* @author Sven Hasselbach\r\n\u00a0* @category URL\r\n\u00a0* @category Proxy\r\n\u00a0* @version 0.2\r\n\u00a0*\/\r\npublic class URLReader {\r\n\r\n\u00a0\u00a0 \u00a0\/\/ Constants\r\n\u00a0\u00a0 \u00a0private final static String PROPERTY_COOKIE_NAME = \"Cookie\";\r\n\u00a0\u00a0 \u00a0private final static String PROPERTY_DOMAUTHSESSID_VALUE = \"DomAuthSessId=\";\r\n\r\n\u00a0\u00a0 \u00a0\/**\r\n\u00a0\u00a0 \u00a0 * reads data from a given URL\r\n\u00a0\u00a0 \u00a0 * \r\n\u00a0\u00a0 \u00a0 * @param pURL URL to load data from\r\n\u00a0\u00a0 \u00a0 * @param pSessionId session data for doing a request in the current user context\r\n\u00a0\u00a0 \u00a0 * @return String containg the result of the http request\r\n\u00a0\u00a0 \u00a0 * @author Sven Hasselbach\r\n\u00a0\u00a0 \u00a0 * @category URL\r\n\u00a0\u00a0 \u00a0 * @category Proxy\r\n\u00a0\u00a0 \u00a0 * @version 0.2\r\n\u00a0\u00a0 \u00a0 *\/\r\n\u00a0\u00a0 \u00a0public static String read( final String pURL, final String pSessionId ){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0String data = null;\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0try{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ init the URL connection\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0URL url = new URL( pURL );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0URLConnection uc = url.openConnection();\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ \"steal\" the original user session cookie\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if( !(\"\".equals(pSessionId)))\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0uc.setRequestProperty ( PROPERTY_COOKIE_NAME ,\r\n \u00a0PROPERTY_DOMAUTHSESSID_VALUE + pSessionId);\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ do the HTTP request\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0BufferedReader in = new BufferedReader( \r\n new InputStreamReader( uc.getInputStream() ));\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ process the data returned \r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0StringBuffer strBuf = new StringBuffer();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0String tmpStr = \"\";\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0while((tmpStr = in.readLine()) != null ){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0strBuf.append( tmpStr );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0data = strBuf.toString();\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}catch(Exception e){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0e.printStackTrace();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0return data;\r\n\u00a0\u00a0 \u00a0}\r\n}<\/pre>\nSub Initialize\r\n\u00a0\u00a0 \u00a0Dim session As New NotesSession\r\n\u00a0\u00a0 \u00a0Dim db As NotesDatabase\r\n\u00a0\u00a0 \u00a0Dim dc As NotesDocumentCollection\r\n\u00a0\u00a0 \u00a0Dim doc As NotesDocument\r\n\u00a0\u00a0 \u00a0Dim isFirst As Boolean\r\n\u00a0\u00a0 \u00a0Dim contextDoc As NotesDocument\r\n\u00a0\u00a0 \u00a0Dim hlp\r\n\u00a0\u00a0 \u00a0Set contextDoc = session.Documentcontext\r\n\u00a0\u00a0 \u00a0Set db = session.Currentdatabase\r\n\r\n\u00a0\u00a0 \u00a0' get the search string from the URL or use the default search\r\n\u00a0\u00a0 \u00a0hlp = Split( contextDoc.QUERY_STRING_DECODED(0), \"search=\" )\r\n\u00a0\u00a0 \u00a0If UBound( hlp ) = 0 Then\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0Set dc = db.Ftsearch(\"[FirstNAME] CONTAINS AARON\", 0)\r\n\u00a0\u00a0 \u00a0Else\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0Set dc = db.Ftsearch(hlp(1), 0)\r\n\u00a0\u00a0 \u00a0End If\r\n\r\n\u00a0\u00a0 \u00a0' create the JSON output\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0isFirst = true\r\n\u00a0\u00a0 \u00a0Set doc = dc.Getfirstdocument()\r\n\r\n\u00a0\u00a0 \u00a0' special content type domino\/json\r\n\u00a0\u00a0 \u00a0Print |Content-type: domino\/json|\r\n\u00a0\u00a0 \u00a0Print\r\n\u00a0\u00a0 \u00a0Print |{\"data\":[|\r\n\u00a0\u00a0 \u00a0While Not doc Is Nothing\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0If Not isFirst Then Print \",\"\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 Print |{\"LastName\":\"| & doc.LastName(0) & _\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0|\",\"FirstName\":\"| & doc.FirstName(0) & |\"}|\r\n\u00a0 isFirst = False\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0Set doc = dc.Getnextdocument( doc )\r\n\u00a0\u00a0 \u00a0Wend\r\n\r\n\u00a0\u00a0 \u00a0Print |]}|\r\n\r\nEnd Sub<\/pre>\n