Skip to Content
0
Former Member
Aug 08, 2008 at 04:00 PM

Crystal Report 9 slow down when we move old DB to new DB server

50 Views

We are using Crystal Reports 9 version, recently we move to new database server and reports data source are pointing to Old database server and old database server is no longer in the network.

Now we have issue with the performance when we call the reports from web application, it is talking long time to retrieve the simple report data(e.g. 1 min.). , if we manually update the report data source pointing to new server and the reports are pulling data very quickly.(e.g. 1 second for the same report) Is there any easy solution to bulk update all the reports datasource pointing to new server, we have 1000 reports, we can not use manual process, it will take long time and it is also issue with the future if we change the server.

Thanks for your help!

Ram

Edited by: ram vaishnapu on Aug 8, 2008 8:09 PM

Edited by: ram vaishnapu on Aug 8, 2008 8:12 PM