I can upload you a little sample Project, which can show the problem. In my sample Project there you can have a sateless session, but this sample project should imitate our greater project so we can't use a stateless. Stateless can't use our user rights in the application.
In the sample project, i'm opening the session, write Data in the two tables and create from these data the reporting tablae. After all done, i close the session. Am Mittwoch, 10. September 2014 00:36:37 UTC+2 schrieb Gunnar Liljas: > > Can you describe: > > 1. How you are managing the sessions. When are they opened and when are > they closed? > 2. What problems you are experiencing with stateless sessions? > > 2014-09-09 13:27 GMT+02:00 Marius Schröder <[email protected] > <javascript:>>: > >> Hello, >> >> thank you for your fast response. We thought and tested our program with >> a stateless session, but we cant implement it. We have to use user rights >> in our queries and thats the problem with the stateless. >> >> Am Dienstag, 9. September 2014 13:20:50 UTC+2 schrieb Ricardo Peres: >> >>> Why not use a stateless session instead >>> (sessionFactory.OpenStatelessSession()) >>> and do all your queries for reporting with it? >>> This way, entities will not be kept in memory and no need to Clear() the >>> session. >>> >>> RP >>> >>> On Tuesday, September 9, 2014 11:52:04 AM UTC+1, Marius Schröder wrote: >>>> >>>> Hello, >>>> >>>> I have a big performance issue in our program. >>>> >>>> Simplified: I have many tables in a database. >>>> >>>> Now I create some new tables from these data (Create Reportings). >>>> >>>> If I load the data (many datas) from the database for the reportings, I >>>> have a big cache, and it takes a long time > 1h to generate these >>>> reportings... The memory consumption of the generation is also very high. >>>> >>>> If I place some "Session.Clear" into the program, after the loadings, >>>> the time for the generation is a lot faster. Also the memory is smaller. >>>> >>>> *Normal* >>>> >>>> Time average: 1h 23min >>>> Memory average: 230 MB >>>> >>>> *After the Change (Session.Clear)* >>>> >>>> Time average: 0h 25min >>>> Memory average: 171 MB >>>> >>>> I compared the data in the database and they are the same. >>>> >>>> >>>> I hope you understand the problem, and you can help me, why there is >>>> such a big difference. >>>> >>>> Best Regards, >>>> >>>> M. Schröder >>>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
