peterjohnlawrence / com.inova8.odata2sparql.v4

Part of the overall odata2sparql solution, this odata2sparql.v4 module containing the olingo4 dependencies. In other words specifically for odata v4
http://inova8.com/bg_inova8.com/offerings/odata2sparql/
Apache License 2.0
5 stars 5 forks source link

An $expand with a large number of navigationProperties will cause a large and slow Cartesian join #60

Closed peterjohnlawrence closed 6 years ago

peterjohnlawrence commented 6 years ago

At present all expanded navigation properties are included as sub-selects or optional sub-selects. This creates a Cartesian join that results in a very large result-set with many duplicates.

If UNION is used to collect the navigation property results together than this will eliminate the Cartesian join and the duplicates.

It should also fix #52 and #53