> Hello,
>
> I've got a difficult problem that I cannot figure out. I'm working on a
> distributed web application which will be used by approximately 50
concurrent
> users. I have decided to use a distributed Remoting architecture but that'
s
> not the point at all.
>
> Due to the fact that one of the applications main goals is high
performance
> we are debating if it is more useful to put the main calculation routines
in
> stored procedures or to keep them centered in the application core
classes.
>
> To me there is no question that using a fully developed object structure
> (including all complex calculation methods) would increase the quality,
> maintenance and overall the reusability of our calculation components. But
> what about performance?
>
> We store approximately 30.000 complex objects (30 properties and nested
> classes) in our database. Each user will access 5.000 (?) objects in his
> session while searching, etc. p.p.
>
> We plan using NHibernate as an O/R-Mapper. Would the performance be close
to
> stored procedure usage if I use object caching methods offered by the
> NHibernate? Has anyone experiences how much logic should be implemented in
> stored procedures and how much should be written in business objects?
>
> Thanks for any hints at that!
>
> Best regards,
> K. Simons
>