cayleygraph / cayleygraph/cayley

Followup: Improve Postgres performance

Open
#447 1 comment 0 reactions 1 assignee Claimed by @dennwc View on GitHub
performance
Dominant language
Go
Stars
15.1k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

The rewritten table structure of #378 means that nodes are being resolved in another round trip. Though safely cached the round-trips will kill performance.

A follow up on this is to restore some performance by either (a) keeping an encoding on the table as there used to be (subject, predicate, object fields) and parsing them on the Cayley side when they come back from Postgres, or (b) doing an explicit join on the top level.

Or (c), both -- do the parsing in the returning values case, and have a separate optimization iterator that does an explicit join to the nodes table for value comparison.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.