Report Loading Time take long

myintw · Post by **myintw** » Thu Jul 21, 2011 1:59 am

Hi,

I create editable reports and allow clients to change their report as they like. So in my project, i have Template Editors button when we click on that button, all the report templates available are being displayed. Then when we click on one of the specific templates and report designer comes up and user can change or modify the report whatever they like. The problem is we have the same reports, same solution build for clients, but some clients they can access the report designer very quickly but some doesn't. Some, they have to wait about 15sec to get it but others have to wait about 1 min and half. Anyone have idea? please share with me, it is really critical issue for us to fix for our clients. Thanks a lot for help in advance.

Regards,
Win

Post by **Vladimir** » Thu Jul 21, 2011 2:57 am

Hello, Win

Report loading speed depends on several factors:
1. User Internet connection speed
2. Whether other applications use the Internet connection
3. Size of the report
4. Workload of the Internet server

All these factors will affect the report loading speed.

Also plese tell us, do you mean loading time of the report or the designer with the report?

Thank you.

myintw · Post by **myintw** » Thu Jul 21, 2011 3:14 am

Hi Vladimir,

Thanks for quick reply, this issue is really urgent for us. I mean the loading time of the designer with the report. Actually, we have two databases on one server. let say, mydatabase 1 and mydatabase 2. so we tried that on both and we found the report designer comes quickly on mydatabase 1 and takes about 15sec whereas mydatabase 2 takes about 1mins and 35sec. Before I got error message which shows connection timeout. But I changed "compilation debug" to "false" in my web.config and then which is better, but still taking too long. What could be the root of this issue. Thanks a lot for your help and time. I really appreciate it.

Regards,
Win

Post by **Vladimir** » Thu Jul 21, 2011 7:02 am

Hello, Win

You can speed up the designer loading by using the caching of the Flash application. For this plese specify the path to separate directory on the server in AppCacheDirectory property. In this directory should be set write permissions for ASP.NET applications.

Thank you.

myintw · Post by **myintw** » Thu Jul 21, 2011 11:37 pm

Hi Vladimir,

Thank you so much for your reply. I set up as you said, but no luck. May be because of I have no experience in this scenario so could you please tell me a bit more details if you don't mind. If sample or reference was included, that would be better for me. Thanks heap for your help.

Regards,
Win

Post by **Vladimir** » Fri Jul 22, 2011 8:04 am

Hello, Win

For example, your project has the following structure:

Code: Select all

Project
    WebSite\
        TempCache\
        Default.aspx
        Default.cs

The cache folder is relative to the ASPX page with the designer (or viewer):

Code: Select all

For this directory should be set write permissions for ASP.NET applications. If caching is working properly, after the first designer launch in this folder will be written .swf application file.

Thank you.

myintw · Post by **myintw** » Sun Jul 24, 2011 8:10 pm

Hi Vladimir,

Thank you for quick reply, I will try as you said and I will let you know. Thank you so much for your help and time.

Regards,
Win

Post by **Andrew** » Sun Jul 24, 2011 11:43 pm

Hello,

Ok! Please let us know about the result.

Thank you.

myintw · Post by **myintw** » Mon Jul 25, 2011 12:40 am

Hi Andrew,

Sorry, it still not working, i tried as you said. But still no luck. I can send you a link so that you can tested.

Cheers,
Win

Post by **Vladimir** » Mon Jul 25, 2011 5:03 am

Hello,

Please send us the link, maybe it will help solve your problem.

Thank you.