Skip to content

performance: icedisk_rel_table is slow #823

Description

@adsharma
lbug -i xet://datasets/ladybugdb/ldbc-csr/main/cit-Patents-csr/schema.cypher
lbug> profile match (a)-[b]->(c) return a.id, c.id limit 10;
...

is rather slow.

Probably inefficiencies in ice_disk_rel_table.{cpp,h} on how the scan works.
Also potentially screwing up the join order due to the lack of tablestats.

Suggested debug strategy: download the dataset locally, profile the pread system calls using bpfcc-tools.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions