Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
princyinit
Starting Member
3 Posts |
 Posted - 2012-03-15 : 08:45:48
|
| Dear forum members,We have a crystal report running with the execution of SQL query on AS/400 server. There are many reports running without any issues. I would like to highlight one particular report which was showing poor performance. Till January the report was running for almost 1-2 hours to generate the report but from february onwards our report runs for almost 10-12 hours before generate the report. There were no changes to the tables and its indexing. There were no changes to the SQL query also.Could someone please throw light on this issue.Has anyone faced similar issue before?Regards,Princy |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Bad performance of Crystal report using SQL query