Skip to Content
0
Former Member
Apr 05, 2010 at 02:28 PM

Crystal ODBC Connection - Command Object response time

45 Views

Command Objects with Parameters are running very slow using ODBC connection. The same command objects runs fast with Oracle connection. I am using the correct CR drivers 5.1 and Crystal XI. Oracle 10g. It is also happening on other machines (my colleagues) too. I noticed this long back and I thought something was wrong with my SQL query.

It is happening at both Business View DF level and at the report level command object using ODBC connection. There are no issues if I use Oracle Server connection. (Oracle Server connection takes half a minute to add a command; ODBC connection takes more than 10 min to add the command)

It is not happening with all the Queries but only with some queries. Has anybody come across issues like this?

Thanks,

SG.

Edited by: Shamanthreddy on Apr 5, 2010 4:29 PM