Topic
IC4NOTICE: 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.
3 replies Latest Post - ‏2012-12-10T20:34:34Z by SystemAdmin
SystemAdmin
SystemAdmin
300 Posts
ACCEPTED ANSWER

Pinned topic Worklight Database Size

‏2012-12-10T18:23:29Z |
Hi

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
  • SystemAdmin
    SystemAdmin
    300 Posts
    ACCEPTED ANSWER

    Re: Worklight Database Size

    ‏2012-12-10T19:06:18Z  in response to SystemAdmin
    I 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.

    Ralph Pina
    • SystemAdmin
      SystemAdmin
      300 Posts
      ACCEPTED ANSWER

      Re: Worklight Database Size

      ‏2012-12-10T19:07:05Z  in response to SystemAdmin
      Just thought about it some more, tell them to give 1T.

      Ralph Pina
      • SystemAdmin
        SystemAdmin
        300 Posts
        ACCEPTED ANSWER

        Re: Worklight Database Size

        ‏2012-12-10T20:34:34Z  in response to SystemAdmin
        Ok, I found the documentation:

        Internal IBM Worklight Database Tables
        http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m5/index.jsp?topic=%2Fcom.ibm.worklight.help.doc%2Fadmin%2Fr_internal_ibm_worklight_database_tables.html&resultof%3D%2522%2573%2569%257a%2565%2522%2520

        Ralph Pina