They run in sequence, yes.There shouldn't be a perf hit over executing the three of them separatedly or joined.
On Tue, Sep 23, 2008 at 11:14 AM, Roger Kratz <[EMAIL PROTECTED]>wrote: > Thanks. > > > > The strange (?) thing is that these numbers goes from x ms to x seconds > when batching three (pretty complex) queries. Sounds strange to me, they > still run in sequence aren't they? > > > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Ayende Rahien > *Sent:* den 23 september 2008 05:55 > *To:* [email protected] > *Subject:* [nhusers] Re: SNIReadSync > > > > This is the call that actually read from the DB. > > SNI is the SQL protocol. > > The reason that you see those numbers being high is that the DB is > performing more work > > On Tue, Sep 23, 2008 at 2:36 AM, Roger Kratz <[EMAIL PROTECTED]> > wrote: > > Hi > > > > From time to time when analyzing queries, much time are spent in > SNINAtiveMethodWrapper.SNIReadSync when NHybridDataReader is grabbing data > out of the datareader. > > > > I would guess this is more of an ado.net question than nhib, but I'm sort > of in the dark here… I got the impression that I've seen more of this > lately. Can it be something with net 3.5:s sp1? The reason I send this here > to the nhib forum is because when using a MultiQuery, these number from time > to time go sky high, but when using single selects, the numbers are low. > > > > Google is pretty quiet in this matter. Any ideas someone? > > > > Time to sleep. > > Roger > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
