I'm refactoring legacy project with many views. Currently it works rather quick by simply selecting data from view. But after refactoring selecting slows perfomance. I looked through the sql send to db, it almost the same, except some aliases set to fields, but this view doesn't has any primary key, so in order to make it work in fluent nhibernate i added a complex key. View has about 10k of rows. So I think delays are on the client side according to some nhibernate key checks. Can smbd help resolve this? Thanks.
well actually the current docs of nhibernate talk about the draw backs of composite Id, as an a alternative solution you might add a simple key and do a query over the unique fields, this should be faster.