and a little bit messy -LW
|
|
|
|
good chemistry is complicated, and a little bit messy -LW |
|
| PerlMonks |
Re^2: DBIx::Class and many-to-many searchingby zby (Vicar) |
| on Jun 02, 2006 at 08:32 UTC ( #553241=note: print w/replies, xml ) | Need Help?? |
|
I would like to hear what a DB expert would say about this. My intuition is that my query, even if it might use quite a bit of joins, it still does everything using indexes - while your 'HAVING' clause needs to count things and than filter and for big data set shall be inefficient. But I am no expert here.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||