The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Improving performance for Saleslogix 7.5 web clients
Posted: 05 May 10 1:50 AM
|
We have recently upgraded to SLX 7.5.2. We are on Windows 2008 Server and SQL server 2008
Each time we launch Saleslogix, a blank screen comes up with the word “loading…” and it takes up to 30 seconds for the home page to load and about 6 -10 seconds to launch each menu – Contacts, Account or even editing a contact. If you have accessed it once, it stays at about 3-4 seconds to access contacts, accounts or any othe rmenu. When you log off and access again, reverts back to the 14 -15 seconds to launch homepage and so on.
We only have about 5000 contacts. I would like to achieve the 1 - 1.5 second as reviewed in your website. Any tips?
Thanks
|
|
|
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 05 May 10 1:56 AM
|
There are many things that you need to look into it, but here are the basics:
- Precompile the site. (Based on your symptoms, this is the more likely cause).
- Depending on the Number of users you have, add additional Instances (this will help you better utilize your Hardware resources).
- Change Default Groups to something other than the "All xxxx"
- You will also need to look into your DB to determine if there are any issues that need to be addressed.
- Review your customizations, make sure that your code is "optimal"
- Review your hardware resources. |
|
|
| |
| |
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 06 May 10 12:07 AM
|
I should have mentioned the following
you need to fine tune your sql server, windows operating system and IIS tuning.
For SQL tuning try to get your database indexes set to clustered and non clustered indexes where ever required as in all tables such as TACO(tickets,accounts,contacts,opportunities) and may be you need to look at areas like seccode tables
once the indexes are set you may want to try checking the sql generated using the slx profiler tool, and then monitor the output of reindex statements.
do not create 1:1 extension tables for TACO like it was done in some implementations before, try adding your fields in the core tables itself.
improve your iis by fine tuning iis using the iis resource kit, there are some values you may want to manually modify(while doing this please note this is not supported by sage)
locate gzip (gzip.dll) from internet and add it to web service extensions remember gzip is a isapi dll which will be prohibited by iis, you may have to enable it manually, you would need to use gzip to set up http compression
avoid indexing of the saleslogix website, there are several other things you would need to do to achieve the required performance.
|
|
|
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 06 May 10 12:10 AM
|
I checked with one of our developers.
He says the SalesLogix application is based on .Net aspx and C#, and that the dll are the outputs of pre-compilation.
He wants to know if you could please elaborate what steps we need to take in order to follow your "pre-compilation" suggestion.
We only have 20 concurrent users and a maximum of 5 at a time.
The servers are built new and has enough resources. CPU hardly ever gets used.
I have changed the default group.
There seems to be no issue at the DB end.
|
|
|
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 06 May 10 12:38 AM
|
Regarding Pre-Compilation:
From within Application Architect, under Deployments, there will be a checkbox for each portal being deployed that will Precompile the site.
You can tell when it has been pre-compiled because the Code Behind files are not found on the Site (because the Code behind gets compiled into DLLs).
Regarding DB Performance, run the SLX Profiler on the Web Server and check how long it takes it to perform the queries. Also, make sure you use the TCP Library for SQL client, I have seen several instances when using other Protocols cause SLX to be quite slow (because each connection had the overhead of authentication, and the local DCs were not available, but once I forced TCPIP library performance went back to normal). |
|
|
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 07 May 10 1:22 PM
|
I had an issue with a client where the clients computers where the problem. I solved it upgrading the clients computers to Internet Explorer 8 but setting the portal to IE7 compatibility. That allowed IEs to improve a lot of performance because of the new Javascript engine but having the old style rendering.
Also we had to disable complements on some computers. Things like $k&pe, the Sun Java Helper, they make the SLX experience a lot slower...
I've founded IE7 spectaculary slow to render Saleslogix Portals.
Try loading the page from the server itself and compare times.
You first need to find your specific issue to improve performance. |
|
|
| |
|
Re: Improving performance for Saleslogix 7.5 web clients
Posted: 10 May 10 2:23 AM
|
Thanks for your feedback.
It behaves the same on both Production and test servers, both from the server itself and from the desktop.
We have a SOE with all the filters and web security applied. So there are not many add-ons.
I have tried IE8 and its the same. So not sure what the issue is.
It worked fine when this was implemented on 2005 servers. The problem started when we moved to 2008 server.
|
|
|
| |
|