Naz, once the fix is in place, you can do it in the mappings by adding type="AnsiString(LENGTH)" to each string property.
On Oct 30, 5:08 am, Naz <[email protected]> wrote: > Hi > Although passing large default parameter sizes is still not a good > idea with MS SQL since the database potentially might start holding > large nvarchar(4000) parameters in memory. SQL Server is fairly smart > and will just make sure it has the memory available to hold it but > only use the memory required and not allocate the full amount. > > This is still a lot better situation than not re-using execution plans > and/or filling up your server full of them to the point it starts > dropping plans so although the fix isn't perfect it's so much better > than the current behaviour. > > The ideal situation is alongside the fix you set parameter sizes in > your mapping that match your table or if your to lazy to do that then > at least if you know most of your nvarchar fields are say 255 length > make that a default convention and only specify larger if required. > > Regards, > > Naz > > On Oct 29, 1:55 pm, zvolkov <[email protected]> wrote: > > > Ok, implemented these changes in the next version of my app, goes to > > PROD around New Year. > > > On Oct 29, 12:09 am, Fabio Maulo <[email protected]> wrote: > > > > 2009/10/29 zvolkov <[email protected]> > > > > > Fabio, my point is: if SQLServer is changed to always call > > > > SetParameterSizes and SetParameter does not specify the size, NH will > > > > simply default to nvarchar(4000), so what's the problem? > > > > Try it with a app in prod. never set parameter size in your queries and > > > pray. > > > If all is working as you expect and your DBA is happy let me know > > > (opening a > > > JIRA with needed info). > > > > -- > > > 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 -~----------~----~----~----~------~----~------~--~---
