Topic
  • 3 replies
  • Latest Post - ‏2012-12-10T20:34:34Z by SystemAdmin
SystemAdmin
SystemAdmin
300 Posts

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

    Re: Worklight Database Size

    ‏2012-12-10T19:06:18Z  
    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

    Re: Worklight Database Size

    ‏2012-12-10T19:07:05Z  
    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
    Just thought about it some more, tell them to give 1T.

    Ralph Pina
  • SystemAdmin
    SystemAdmin
    300 Posts

    Re: Worklight Database Size

    ‏2012-12-10T20:34:34Z  
    Just thought about it some more, tell them to give 1T.

    Ralph Pina
    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