Very Slow Report
Very Slow Report
Hello
I have two problem in my report :
1) first if i'm using simple cross tab report with 23386 row exactly for first run it take long time in registering the data in report
and in the next run it give me this exception : (An exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll but was not handled in user code) , for another report with 21966 row not give this exception at all i don't know what the difference!
2) second problem when i use report with some relations and enable cache all data property it take very very long time in rendering the report then i stop running the report before dispaly it ! what is the problem do u think?! and i'm using render mode = ajax with cache
I have two problem in my report :
1) first if i'm using simple cross tab report with 23386 row exactly for first run it take long time in registering the data in report
and in the next run it give me this exception : (An exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll but was not handled in user code) , for another report with 21966 row not give this exception at all i don't know what the difference!
2) second problem when i use report with some relations and enable cache all data property it take very very long time in rendering the report then i stop running the report before dispaly it ! what is the problem do u think?! and i'm using render mode = ajax with cache
Re: Very Slow Report
Hello.
Thank you.
The difference in in amount of memory that need for report. Please, read the The Out of Memory exception while rendering a report article from our Knowledge Base.G.hammad wrote:1) first if i'm using simple cross tab report with 23386 row exactly for first run it take long time in registering the data in report
and in the next run it give me this exception : (An exception of type 'System.OutOfMemoryException' occurred in Stimulsoft.Report.dll but was not handled in user code) , for another report with 21966 row not give this exception at all i don't know what the difference!
Please, send us a sample project with more detailed description of the problem. We need to analyze it before we give your any advice.G.hammad wrote:2) second problem when i use report with some relations and enable cache all data property it take very very long time in rendering the report then i stop running the report before dispaly it ! what is the problem do u think?! and i'm using render mode = ajax with cache
Thank you.
Re: Very Slow Report
Hello
this sample project for used relation and cache all data it take time in register data if number of records more than 23,000 records
but the most important it take long long time in render as u can see in the sample
thank you
this sample project for used relation and cache all data it take time in register data if number of records more than 23,000 records
but the most important it take long long time in render as u can see in the sample
thank you
- Attachments
-
- WebApplication2.rar
- (83.79 KiB) Downloaded 300 times
Re: Very Slow Report
Hello.
We need some additional time for analyzing of the issue.
We will let you know about results.
Thank you.
We need some additional time for analyzing of the issue.
We will let you know about results.
Thank you.
Re: Very Slow Report
Hello Aleksey
good thats mean you see the problem
ok i'll wait your answer
thank you.
good thats mean you see the problem
ok i'll wait your answer
thank you.
Re: Very Slow Report
Hello.
Could you specify what type of report do you need to generate.
If there is an only column then it's better to avoid using cross-tab and use the Data Band.
Thank you.
Could you specify what type of report do you need to generate.
If there is an only column then it's better to avoid using cross-tab and use the Data Band.
Thank you.
Re: Very Slow Report
Hello Aleksey ,
no i want to use cross tab since it generate more than one column and my data register to report have more than one column for example
if i choose get all data i need for one month then i need 30 columns each column represent specific day and date of month so for that reason i used cross tab
no i want to use cross tab since it generate more than one column and my data register to report have more than one column for example
if i choose get all data i need for one month then i need 30 columns each column represent specific day and date of month so for that reason i used cross tab
Re: Very Slow Report
Hello,
We are working on the issue. We will let you know about the result.
Thank you.
We are working on the issue. We will let you know about the result.
Thank you.
Re: Very Slow Report
Hello ,
do you solve the problem ? or at least know what the problem ?! i need to solve this problem in my report as fast as i can
do you solve the problem ? or at least know what the problem ?! i need to solve this problem in my report as fast as i can
Re: Very Slow Report
Hello,
We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.
Thank you.
We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.
Thank you.