Speeding up query

Neo4j Graph Platform Cypher
1

Hi,

are there some solutions for my query below to speed up?

match (a:keyWord{kwValue:'zhou'}),(s:Product)
using scan s:Product
where s.seriesCode in ['110300027060','221000058301','110300107740','110300026540','110300027150','110300026720','110300107560','221005089502']
with a,s
match (a)-[:found]-(user:User)-[:view]-(s)
with user,s
return s,count(user) as foundView

Profile

%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20190315101720
微信图片_20190315101720.png493×587 18.2 KB

Best wishes
Grant

2

Read this

Share your PROFILE output.

Do you have an index/constraint on :keyWord(kwValue) ? and one on: :Product(seriesCode)

  • Remove the using scan
  • Add directions to your relationships.
  • remove the withs
  • use parameters
4

Thanks, im going to try these solutions.