Posted: 20 Nov 2015 10:25 EST Last activity: 28 Jun 2016 22:27 EDT
Is it adviable to store huge data on Data Pages if they are stored in Shared Storage.
We came across a requirement , and would like to make use of Data Pages rather than Database Table to avoid expensive DB Calls. And what we are going to store on this Data page is the recent cards history of a CCP. I have below questions on this...
Are Node levelvdata pages stored in the shared storage, i.e. In a clustured env even if a JVM crashes, can we get this information from the shared storage.
If indeed they are stored in the shared storage, would they be copied to shared storage on a time to time basic or would they be stored in the shred storage from the very beginning.
Is it advisable to store huge amounts of data on a Data page in the shared storage.
Data Tables and Data Pages (formerly known as Declare Pages) are not mutually exclusive. Data Pages are not intended to replace Data Tables and in fact they can be used together.
Data Tables are still supported in Pega 7 and they continue to be referred to as Data Tables. You can also still edit the contents of a Data Table the same way we did in previous versions of PRPC. Simply select DesignerStudio > Data Model > Data Tables > Data Tables.
The enhanced Data Table Wizard in Pega 7 now can also create two (2) optional Data Pages for you to easily reference the Data in your Data Table. The two Data Pages are a List (D_List) to be used to retrieve the entire list of entries in your Data Table and a Page (D_Page) to retrieve the details for only one entry in your Data Table.
Node Level Data Pages are instantiated in each JVM Node Running the PRPC Web Application as they are referenced. Not every Node in your Cluster of PRPC Application Servers needs an instance of a given Node Level Data Page, only those Nodes wherein the Data Page is actually referenced and used. All Requestors on that Node can then share the contents of the Node Level Data Page.
Here is the thing. We want to store the recent cards the CCP has serviced in last 12 hours. There are 200 CCPs taking an average of 80 calls. We dont want to store this information in the database to avoid the huge database calls.
We want to store this information in the Data page and store it from the clipboard. The only thing that we are trying to capitalize is pega's new capability of storing the data pages in the shared storage.
1. Are Data pages are stored in Shared Storage.
2. If all the Data pages are stored in shared storage, whats the point of having the scope.
3. If a node level data page is stored in shared storage, can that data page is accessed from another node.
In my opinion, storing huge amounts of data on clipboard isn't a good idea. It's just occupying your memory for minimal use. Unless this data is very frequently used such as every 2 minutes or every minute.
Lot of developers tend to use data pages as they sound fancy and forgetting the fact that there is no huge performance improvement by storing 300k records on clipboard which is accessed only 5 or 6 times a day.
Here's a table which I think is appropriate.
Data Pages can be used?
Minimal data frequent use
Minimal data in-frequent use
Huge Data frequent use
Huge data in-frequent use
Frequent use in my opinion - Used on every case or used every 5 minutes or so