开发者

Crystal report subreport very slow after database upgrade

We upgraded sql server database from 2000 to 2008. Crystal report with a subreport was taking around 50 seconds on 2000 database now same report is taking 3 minutes. I don't ha开发者_Python百科ve a clue what's the problem?

Thanks!!!


Update usage counters: In earlier versions of SQL Server, the values for the table and index row counts and page counts can become incorrect. To correct any invalid row or page counts, run DBCC UPDATEUSAGE on all databases following the upgrade from 2000 to 2008.

You should also rebuild your indexes (and ensure column statistics are updated).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜