Printing extremly slow

82 Views

Hey,

we are using Crystal Reports 2011 with .NET 4.0 on a Windows 2008 R2 64-Bit terminalserver.

The printing is very slow. Printing each document counts 5 - 10 minutes. The informix database is very fast (normal queries are fast).

I have enabled the logging and found out the block where the wait time begins:

|a8235f38-a552-f7d4-b881-915225a00c6c|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||..\..\src\print\datasource\datanode.cpp:695,DataSet checking for datasource changes,Starting to check current datasource for changes,""

|857453c6-3d61-1c44-c801-c4d1048186bd|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||N/A:-1,DataSet checking for datasource changes,Elapsed Time,"0"

|04b5ca97-ee4b-03f4-4a9a-331c8fc024a3|2011 12 20 08:56:43:678|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2629:1||||||||||||N/A:-1,Checking for data source changes,Elapsed Time,"1"

|9c0de6ee-fd0f-2034-7bc4-457c848236b6|2011 12 20 09:02:08:366|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1||||||||||||..\..\src\print\datasource\dsmgr.cpp:3347,Checking for data source changes,Start Time,"09:02:08"

|2bc4406c-ec0b-ee84-d863-d0525143b2b0|2011 12 20 09:02:08:366|+0100|==| | |Diagnostics| 5152|6012|| |0|0|0|0|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1|-|-|CRPE.CRPEBackgroundThread|localhost:5152:6012.2630:1||||||||||||..\..\src\print\datasource\datanode.cpp:573,DataSet checking for datasource changes,Start Time,"09:02:08"

What is crystal reports doing at this point?? What could be the reason for this long delay while generating the report?