Performance tuning in CE 10

[jchennuri]

Hi :

What is the best way to improve the performance of CE 10 Server? End users are complaining that - its taking lot of time to open a requested page/refresh a page?

Thanks
JC

 

[eyeswideclosed]

That's a huge area, but you should at least have lots of cpu horsepower and memory, multiple page/job/cache servers set up, the latest service packs, and make sure you're killing your CE/CR objects in whatever code you have calling the reports as soon as it's finished with them, also if you're using .net it's critical that you are using Dispose() everywhere prior to releasing the objects. Also look at your data access method to make sure it's the latest, i.e., oledb instead of odbc, native db drivers preferrably, and use stored procs whenever possible. Like I said it's a huge area.

 

[jchennuri]

Hi Hejamana:

Thanks a bunch for your reply. Is there any check list kind of thing to ensure better performance.

Regards,
Jagadish.

 

[eyeswideclosed]

Not that I know of, but those are the main points. Of course if you have a report with an extremely complex query hitting an inefficient database CE configurations won't help much, you really need to find out exactly where the problem is.

 

[Turkbear]

Hi,
Slow to Open/Refresh pages in what app - EPortfolio or some custom pages ?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bessebo]

we are having a similar issue. if you click on History it may take a while to pull up the history.