pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1121484835
It looks like I have been a bit too enthusiastic in my previous comments.
### Property constraints
When using GIN indices on properties and creating relations using these
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1120878414
Commit
https://github.com/apache/incubator-age/commit/379983b0cefa92aff89eb8d641e05bb376c83862
includes some improvements which are relevant here:
* agtype_access_operator is
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1109525588
Wow, this is fantastic. It is now possible to create relations quickly (~10
000/s on my local VM) using simple queries (with executemany) in the form of
```
SELECT * FROM
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1108412682
Thank you for the update! Is it possible to explain in more detail what
issue was resolved?
I tried creating a unique index as described in
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-982438807
This is great, thank you!
Since indices require an immutable function, an additional function will
still need to be created for them. When I create a `get_id` function with
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-908222122
When the edges are inserted in the specific edge table, they are
automatically added to the `_ag_label_edge` table, reducing the workaround to
the following and making the
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-902711546
I found a (1000 times faster) workaround for the creation of edges between
vertices that were added earlier. The workaround consists of inserting the data
directly in the
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-845153669
I tried using id() instead of using properties for matching, but this was
even slower (I noticed using an additional `WHERE` clause instead of defining
properties in the `MATCH`
pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-812524846
It would indeed be very useful to enable the creation of constraints /
indexes. This could help to accelerate the creation of edges between nodes that
were added earlier, which