great idea and what about the performance like for millions of record may be you can say i am over engineering it but actually i want to make system scale able .
so two questions with reference.
1: what if date node dosen't exist it should create in that situation .
2: is this solution suitable for millions of record . ?
i have tested some thing like this .
query 1 : match parent node and option match date and time .
then on the basis of this result i am creating missing nodes . so lets say if date was not there and of-course in that case time also not there so creating both nodes .
so basically 2 queries for proper insertion . and these queries are taking 5 ms total . so a complete data along with relation is persisting in 5 ms time is to costly :(
once again Thanks in advance
Get Certified in June!
