Crystal Enterprise XI slow

[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.

 

[Drazzst]

Great, my first post and i've already messed up. Sigh...definitely a Friday.

In anycase, Crystal Enterprise XI is not involved, it's Crystal Reports XI. Sorry for the confusion.

 

[MJRBIM]

You probably want to post this in a different forum -

http://www.tek-tips.com/threadminder.cfm?pid=766

 

[Drazzst]

Thank you. I've posted it to the other forum, but I'm not sure how to delete this thread. I love being a newbie. *sigh*