02-08-2012 01:53 PM
Any other BPs out there run into performance issues with SalesLogix Web running on Oracle? I am running into a scenario where the web client is extremely slow against a fairly large database. Almost every request made ends up timing out. Most of the implementations I have worked on are SQL Server. I am familiar with all of the tuning options that can be done on the web server, even on the browser. I would think that the issue is the Database and how its configured/tuned.
Is there a "gotcha" or something specific that has to be done to the Oracle DB to make SalesLogix Web run optimal? Or is it a known and accepted fate, that SLX Web and Oracle will be slow.
02-08-2012 02:13 PM
You need to take a similar approach:
Use SLXProfiler and trace your Queries. Find those that are taking a long time executing and try to tune them on the Oracle End.
The same way as with SQL, you will need to add/rebuild indexes to get an optimal performance.
If the Profiler shows that the problem is not on the DB end, then you need to look at your Web Servers and then look into your Network and Clients.
02-09-2012 02:05 AM
02-09-2012 09:11 AM
There are a lot of factors that can contribute to poor perfromance in Oracle. The clients should have internal DBAs that can assist in tuning. Sime things to look at at the DB level are:
Also, be sure to run the create oracle views script on the install media.
Beyon that, it could be an indexing problem, or the DB needs to have statistics updated. This is fairly common after an initial data load.
What version or Oracle are they running and on what platform?