Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-216

improve filtering performance

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Normal
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Steps to Reproduce

      1. load the attached file
      2. use the filter in the sheet

      Current Result

      under the customer's environment":

      1. 18000 rows X 250 columns
      a. Click the filter column to popup Filter Dialog - about 3.5 - 4 seconds
      b. Filter data - about 5 - 15 seconds
      c. Clear Filter - about 15 seconds
      2. 5000 rows X 250 columns
      a. Click the filter column to popup Filter Dialog - about 1.5 -2 seconds
      b. Filter data - about 1.5 - 4 seconds
      c. Clear Filter - about 1.5 - 3 seconds

      Expected Result

      1. 18000 rows X 250 columns
      a. Click the filter column to popup Filter Dialog - less than 1 seconds
      b. Filter data - about 1 second
      c. Clear Filter - about 1 - 1.5 seconds
      2. 5000 rows X 250 columns
      a. Click the filter column to popup Filter Dialog - less than 0.5 seconds
      b. Filter data - about 0.5 seconds
      c. Clear Filter - about 0.5 seconds

      Debug Information

      • This expected time is based on the customer's current applet/Web Start application. They hope a keikai-based application can perform as well as their existing application. So that their end users can accept the performance.
      • Test file - 18000 rows

      Related Technology

        Attachments

          Activity

            People

            Assignee:
            wenninghsu wenninghsu
            Reporter:
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: