Skip to content

Manually invoking the GC leads to very bad performance if you read many files #252

@steffenhaug

Description

@steffenhaug

I have a workload where i read thousands of Excel files, and using openxlsx without do-syntax is several orders of magnitudes faster, because over 99% of the time is spent GCing when I use do-syntax.

I'm fine with manually closing the file, but it would be nice if it was documented that using do-syntax manually invokes the GC, or if there is another way to solve the bug on Windoes that manually invoking the GC is suposed to fix.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions