Skip to content

Slow performance of insert_many when creating new timetable #576

@lukeskywalker22

Description

@lukeskywalker22

Problem

Calling campus.api.timetable.new() with full timetable data results in a timeout (60 s).

Verification: Calling campus.api.timetable.new() with a smaller json file does not produce the timeout observed with the full timetable json file, likely a performance issue on the backend server.

Resolution

Implement optimised insert_many() method for postgres/mongodb backends, optionally for sqlite/memory backends (used for testing only)

Tasks

  • Implement SQLiteTable.insert_many()
  • Implement MemoryCollection.insert_many()

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    Status

    Planning

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions