empty relationship qualifier question
empty relationship qualifier question
- Subject: empty relationship qualifier question
- From: "Michael Bushkov" <email@hidden>
- Date: Fri, 4 Jul 2008 12:32:34 +0400
Hi,
I have quite simple task, but I don't see any proper solution. The
task is as follows:
I have 2 entities - Song and Track. Song has a one-to-many
relationship to Track (Song->tracks). And I need to fetch all songs
which have no tracks. That's all - plain and simple.
I've looked through the list of available qualifiers and even started
to write one by myself, but it looks like an overkill for such a
simple task. The straightforward solution, that I see is to cache
number of tracks in Song entity (make a Song->tracksNumber field). But
it looks like modifying model for implementation purposes (this
however can be very effective on large datasets, because such database
structure doesn't require using subqueries to find songs with no
tracks).
Any suggestions are greatly appreciated )
--
With best regards,
Michael Bushkov
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden