03-02-2012 10:27 AM
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.
03-02-2012 10:43 AM
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)