Jetspeed 2
  1. Jetspeed 2
  2. JS2-1090

Jetspeed 2.1 derby database becoming huge.

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.1-RC
    • Fix Version/s: 2.2.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      Windows 2003 SP2

      Description

      The customer has 2 portlet applications. one with 36 portlets and the second one with only 1 portlet. The customer is complaining that there are a couple .dat files that are taking up a large amount of space:

      ...jetspeed\2.1\database\derby\productiondb\seg0:

      c3c0.dat (12.5 GB)
      c3d0.dat (8.78 GB)

      There are 283 other *.dat files in the same folder of much smaller size. Does this amount of space seem reasonable for the amount of deployed portlets? Is there any way to reduce this size?

        Activity

        Hide
        Nishant Malviya added a comment -

        deleting the rows is not releasing the memory, can you suggest further ?

        Show
        Nishant Malviya added a comment - deleting the rows is not releasing the memory, can you suggest further ?
        Hide
        Nishant Malviya added a comment -

        Hi David,

        Here is some more detail from our customer:

        They have 85 users (3 built-in), 40 pages, 6 roles (5 built-in), 1 group (all users are members of this group and they don't really use this group anywhere). The built-in admin security constraint is assigned to 5 pages, so that only admin users can see those pages. All the other users see the same pages with the default security.
        regards

        Nishant

        Show
        Nishant Malviya added a comment - Hi David, Here is some more detail from our customer: They have 85 users (3 built-in), 40 pages, 6 roles (5 built-in), 1 group (all users are members of this group and they don't really use this group anywhere). The built-in admin security constraint is assigned to 5 pages, so that only admin users can see those pages. All the other users see the same pages with the default security. regards Nishant

          People

          • Assignee:
            David Sean Taylor
            Reporter:
            Nishant Malviya
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development