JoinedLoad of labels and notes

[koenedaele]

In a few methods we are not using a joinedload on labels and notes. See

• _get_concept_scheme: Returns notes and labels but doesn't load them with the concept. Forcing 2 extra db queries
• get_by_id: Returns a concept. Joined loading the most needed relations (labels and notes) would save 2 queries.
• get_by_uri: Returns a concept. Joined loading the most needed relations (labels and notes) would save 2 queries..

[koenedaele]

@BartSaelen If you have no objections, I'd let @TalissaJoly handle this.

[koenedaele]

Some quick tests show that this improves performance with a postgresql database. But it might reduce performance for an in-memory SQLite database. Still, that's not a common usecase.