My database administration team is asking me to provide the maximum database size WL needs instead of telling them auto extendable. Can some body tell me what size should i tell them for one year?
Following are the few more details:
Number of users using one application : 10000
Number of applications : 3
Database to use : Oracle 11g
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2012-12-10T20:34:34Z by SystemAdmin
Pinned topic Worklight Database Size
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Re: Worklight Database Size2012-12-10T19:06:18Z in response to SystemAdminI can't find it in the new docs, but there used to a paragraph about cleaning up your reports database often, because if you turn on raw data, it will fill up quickly. It said it could hit GBs pretty quickly.
If you are not storing raw data, the actual database for the WL server is pretty small. My WL Server's DB using MySQL has less than 7 MB, and I have 4 apps, each with 2 or 3 wlapps, and 1 total adapter.
So if you work for a big ol' company, ask for like 100 GB just to be safe.
Re: Worklight Database Size2012-12-10T19:07:05Z in response to SystemAdminJust thought about it some more, tell them to give 1T.
Re: Worklight Database Size2012-12-10T20:34:34Z in response to SystemAdminOk, I found the documentation:
Internal IBM Worklight Database Tables