Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Nickel Contributor
Posts: 47
Registered: ‎05-25-2011

WebClient terrible performance - Oracle full table scans instead of using indexes

Hi Everyone,

 

I'm working on a customer where they are experiencing awful system performance in the web client (SLX 7.5.2, no hotfixes applied). They have 2 big web servers and a big app server box (12Gb RAM, 8 processors each box) running against Oracle 10g (again, on a big, big box). They may have around 100 users connected to the web servers, and say 50 more connected through the lan client, all at the same time. 

 

The "All Accounts", "All Contacts" and "All Opportunities" groups take ages to load. We're talking more than a minute here. While investigating with their DBA, it appears Oracle is ignoring all indexes and using full table scans instead, which might explain the terrible performance we're seeing. Have you had similar issues? Any tips on how to approach such a problem, or how to solve it?

 

Any hints or tips would be appreciated.

 

Thanks in advance.

Highlighted
Bronze Super Contributor
Posts: 129
Registered: ‎06-09-2009

Re: WebClient terrible performance - Oracle full table scans instead of using indexes

As you stated, it would be Oracle the one ignoring Indexes and Performing Table Scans.

 

You need to get a DBA to troubleshoot the Database, its indexes and Statistics, because that is where your problems are coming from.

 

If you must, ask for a Querying tool other than SalesLogix, then you could show them that the Queries don't perform well (and take the Application out of the Equation), thus illustrating that this is indeed a DB issue.

 

Once you get Oracle to perform correctly, then you will get SLX working in a better status (but keep in mind that you will need to review Performance and Indexes on an Ongoing basis as the usage of the System changes over time)

 

 

Raul A. Chavez
http://raul.chavez.com
http://www.crmbi.com