We have some JIRAs about various way to run a DELETE. In a specific case of a Clear() without optimistic-lock, probably, DELETE FROM z WHERE z.ParentId = ? is the better solution.
2009/5/17 Graham Bunce <[email protected]> > > That's an "if". > > If your DB doesn't support multiquery then you are stuffed. > > Besides, even if your DB does execute on one trip, if NH submits 500 > DELETE FROM z WHERE id = ? surely its still going to be slower than > one DELETE FROM z WHERE z.ParentId = ? > > As I said, I'm convinced most people coming using Clear() for the > first time expect it to do the latter whereas in fact it doesn't > appear to. After all, that's what a Clear() does in .NET - wipes all > instances from a collection. It makes sense for this to be replicated > in the database. > > Orginally I thought it did the single shot delete and I've seen > several other posts since then from people stating the same thing. > Each time the answer is "its working as intended, raise a JIRA". Well > it may be, but my question is "working as intended" really doing what > it should? > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
