3 ms·
1) I think you want to compare apples to apples. Linking up validated primary key relationships should be faster in OrientDB. I am not sure how you handle other
by gregwebs 13y ago
1) I think you want to compare apples to apples. Linking up validated primary key relationships should be faster in OrientDB. I am not sure how you handle other types of relaitonships.
2) exactly. The tradeoff is that SQL lets you easily do ad-hoc analysis (which isn't an important use case for a lot of applications). But also in SQL you do have to know about foreign key relationships at insert/update time to validate those.
- cwyers 13y agoThat's true for keys, but that really only covers a subset of what JOINs can do -- if I want to use things like dates, times, quantities of things... and frankly, if I want to do something other than JOIN on equal values, say join on greater or less than or between, then that's an entirely different thing altogether.