search

JnBrymn / minglbot

0 stars 0 forks source link

Remove use of `screen_name OR id` because of bad index usage #30

Open JnBrymn opened 9 years ago

JnBrymn commented 9 years ago

Find cases where we're looking up users by id's OR screen_names and remove them because Cypher doesn't know how to use indices when this happens.

MATCH (u:User)
WHERE u.id in {ids} 
  OR u.screen_name in {screen_names}
RETURN u

Alternatively, wait till the new cypher compiler is available and test to see if these queries are still so slow.