Crystal Reports XI slowness issues

[Drazzst]

Here is a problem i'm encountering:

We have Crystal Reports XI setup on a workstation, running Windows XP, that accesses a database through an ODBC connection. When using a particular report, it runs through approx. 10000 records a second.

This same ODBC connection is setup on a server, running Windows 2003 Server, which then queries the database server. When I run the same report on the Windows 2003 Server it only returns 100 records a second.

Does anyone have any ideas as to what might be causing the slower response on the server? I've already verified that the ODBC connection is exactly the same. I've tried disabling AV software, no avail.

Here's a bonus...the workstation is on a remote network segment while the server is on the same segment as the database server.

It's a Friday and i've been racking my brain. Does anyone have any ideas? Thanks in advance.

 

[elsenorjose]

Unless the two machines are identical, it's hard to pinpoint any one thing. I'd assume your server is more robust than your workstation but perhaps not. One thing I would research is if your server is accepting additional connections via it's network interface (it IS a server after all) Might that be causing network resource congestion?

 

[Turkbear]

Hi,
If you have access to the server, try running the report from there in CR designer..If not possible, try running the SQL code generated by the report from that server ( What database by the way?)

As a simple test, open a command window on the server and ping the database server.
Do the same ping from the workstation and compare response times,





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