Direct SA1 Links
Etics Portal - Etics Web - EticsAgendas - ETICS 2 SA1 Savannah - SA1Actions (in Savannah) , SA1 Internal


ETICS DB Optimization

Short Description of the Task

Two scripts have been created: - eticsDBSavingPreCleaning: to save in a file data that it is going to be removed - eticsDBCleaning: to delete old entries previously saved

In the tests done in etics-dev, using as "startDate" 2009-05-31, the results are: - account: from 301107 to 72395 entries --> 76% reduced - accountDelete: from 32322 to 829 entries --> 97.5% reduced - job: from 93555 to 9544 entries --> 89.9% reduced - jobPlatform: from 183489 to 19257 entries --> 89.6% reduced - jobRun: from 182416 to 18203 entries --> 90% reduced

Backup file size: around 196Mb.

Useful Links

Requirements, Ideas, Constraints etc

Open Issues

  • item
  • item
  • item

Plans, Dates and Status

Status

General status and current versions, tags, configuration.

Ongoing work, etc

Future improvements

ToDo

  • date: item:
  • date: item
  • date: item

Done

  • date: item:
  • date: item
  • date: item
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2010-11-11 - MatthiasStein
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    ETICS All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback