To clarify: Does your query work for small data but not with big data?
Then there is a performance issue.
Try running the query with the PROFILE and look at the plan. If the query doesn't filter out large enough nodes, then you could have a combinatorial explosion which will take a very long time and appear not to come back.
See:
And this specific example of using a subquery to speed things up.