If you or someone else has any tip why this is happening to me, any suggestion is welcome. I will investigate this further.
As said, I got the impression that this suddenly "just started to happen" for me recently (=high numbers for MultiQuery). That's why my long shot were to guess it's something to do with .net 3.5 sp1 or maybe some modifications in latter releases of nhib. From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ayende Rahien Sent: den 23 september 2008 10:18 To: [email protected] Subject: [nhusers] Re: SNIReadSync 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]<mailto:[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]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Ayende Rahien Sent: den 23 september 2008 05:55 To: [email protected]<mailto:[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]<mailto:[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<http://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 -~----------~----~----~----~------~----~------~--~---
