Joined: 28 Jun 2011
Online Status: Offline
Posts: 1
Topic: Low Performance with Oracle Client 11g Posted: 01 Jul 2011 at 7:39pm
Hi Experts
I installed Crystal Report Server 2008 on Windows Server 2003. We use Oracle Client 11R2 to create an ODBC to link with an Oracle Database which installed on another Redhat Linux Server.
I found the performance of generating report by server is really bad, it's a really simple SQL query.
Before the Oracle, we used the SQL Server 2005 as the database, the time to open the same report only took 1-3 seconds, but on Oracle it took more than 20 seconds.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged