Skip to content

Reduce database size #418

Open
Open

Description

@bruntib

According to sqlite3_analyzer tool the 3 largest tables are CppDocComment (50.3%), CppAstNode (33.1%) and FileContent (5.0%). Measurement is done on a Xerces parsing.
CppDocComment is this huge, because we're storing the comments in HTML format with a lot of styling. We should remove HTML formatting. We should also consider storing these doc comments as compressed .zip.

  • Storing documentation comments in markdown format instead of HTML
  • Compress documentation comments with ZIP
  • A CSS would be nice for formatting documentation comments in the GUI

Related issues: #417, #21.

Activity

  1. added
    Target: DatabaseIssues related to the database schema of the core or a plugin, or database handling in general.
    on Aug 2, 2020
  2. added this to the Release Flash milestone on Aug 2, 2020
  3. mcserep commented on Feb 4, 2024

    @mcserep
    Collaborator

    I am moving the remaining tasks in this issue to the next release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Target: DatabaseIssues related to the database schema of the core or a plugin, or database handling in general.

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions