Drag & Drop (webdav) very bad performances with Windows 7 and IE9

By jpforti
  • WebDAV Version Management Configuration

    WebDAV Version Management Configuration
    Enable collapse versions within a single editing session set to true.
  • Retention Period set to 93 days on ECMA1P_ACTIVE

    Retention Period set to 93 days on ECMA1P_ACTIVE
  • Windows 7 deployment

    Windows 7 deployment
  • Upgrade to CS 9.7.1 Update 4

    Upgrade to CS 9.7.1 Update 4
  • Period: to

    5 Months without any issues

    PROVIDERRETRY tables growed from 0 row to 300'000 rows
    60% of Windows 7 clients deployed
    5500 users reached
    Security updates installed on Windows 7 clients
    Hotfixes installed on Content Server servers (Windows 2003 SP2)
    1.5 millions documents reached.
  • Queries taking all activity on the Oracle DB

    Queries taking all activity on the Oracle DB
  • Database optimization implemented

    Database optimization implemented
  • Drag&Drop is very slow for Windows 7 users

    Drag&Drop is very slow for Windows 7 users
  • Period: to

    OTCS Support #1602288

    Investigations:
    - IE parameters
    - Firewall on the servers
    - IPv6
    - Windows 7 updates
    - Windows Server 2003 hotfixes
    - ...
  • Oracle Database performance issue

    Oracle Database performance issue
  • 2nd Saves on Windows XP and Windows 7 are very slow

    2nd Saves on Windows XP  and Windows 7 are very slow
  • Webdav ActiveX bug on Windows 7

    Webdav ActiveX bug on Windows 7
  • PROVIDERRETRY table contains 300'000 rows

    PROVIDERRETRY table contains 300'000 rows
    HTTP error (Internal Server Error [500]): Internal error in archive
    server: (ds-error='3060: document retention not yet expired: Document
    baw5x5wczw1e5aa4kppjsdqkifkyk has a retention period of 87 more days')
  • Solution

    Solution
    Option 1
    - Create an index on PROVIDERDATA (as it's a CLOB column, Oracle TEXT must be installed). Option 2
    - Copy PROVIDERRETRY table
    - PURGE PROVIDERRETRY table
    - Create a new volume on the Archive Server without retention and route all documents on this volume
    - In 3 Months, move the rows back into PROVIDERRETRY Option 3
    - Option 1 + Option 2 without the purge Option 4
    - Create an index on PROVIDERDATA
    - Remove the retention period for all new documents