Skip to content

Instantly share code, notes, and snippets.

@nicysneiros

nicysneiros/graph_db_comparison.cql

Last active May 15, 2017 15:15
Show Gist options
  • Save nicysneiros/19fe9e1a3055427dff7912b5d6defa81 to your computer and use it in GitHub Desktop.
Save nicysneiros/19fe9e1a3055427dff7912b5d6defa81 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
graph_db_comparison.cql
MATCH (:User {name: “John”}) -[:LIKES]-> (pages)
RETURN pages
@jexp
Copy link

jexp commented Apr 20, 2017

@nicysneiros this query also misses the colon before :User which again causes a full database scan.
do you have the constraint / index on :User(name)

Also the Titan query returns only the name property, so you might want to do the same here:

MATCH (:User {name: "John"}) -[:LIKES]-> (pages)
RETURN pages.name

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment