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!
|
|
Opportunity Performance issue 
Posted: 03 Dec 07 3:17 PM
|
I have about 141543 opportunities in opportunity table. I have a custom table with one to one relationship with opportunity C_Opportunity_ext.
Users are complaining that the screen is too slow... to paginate, to create new opportunity. we already have indexing on these two tables. what could be causing the slowness and how to speed things up? Any ideas/suggestions please...
Thanks in advance... |
|
|
|
Re: Opportunity Performance issue
Posted: 03 Dec 07 3:19 PM
|
| Forgot to mention that it hangs and have to ctrl + alt + del and kill the app to start again... pagination takes about a minute/ sometimes makes screen white and hangs... any help will be appreciated... |
|
|
|
Re: Opportunity Performance issue
Posted: 03 Dec 07 4:10 PM
|
I found out the issue for the problem. I have salesprocess attached to all the opportunities
select Count(*) from SALESPROCESSES -- 139597
go
select Count(*) from SALESPROCESSAUDIT -- 2651497
It is indexed too. Any ideas on how to speed things up in opportunity screen with such data? |
|
|
|
Re: Opportunity Performance issue
Posted: 04 Dec 07 9:24 AM
|
Rekha,
Here are a few suggestions fro troubleshooting.
1.) Have you verified there are not any triggers firing off of Opportunities such as a pipeline calc?
2.) Another thing you may want to verify; what you are pulling to the System: Opportunity Details page. If you are trying to show everything on one screen it will not only be too busy, but slow down access. Try moving some information to a tab instead.
3.) Make sure users are not trying to pull large groups such as "All Opportunities" or "ALL Open". Have them change their default group to "My Opportunities" and remove user access to the large groupings. They will still have access to the data, but it is probably not necesarry they pull to those large groups. Management may need viewing - but you can efficiently handle that with a daily report.
4.) Lastly, verify ownership. Make sure that the Opportunity.SECCodeID matches that of the Account. Users may experience a very noticable drag or complete system hang (as described above) if the ownership is split up. (even if they do have security rights)
Carla
|
|
|
|
Re: Opportunity Performance issue
Posted: 04 Dec 07 9:39 AM
|
Rekha,
I have had troubles with screens running very very slowly in the past as well, especially the Opportunity Detail view. To solve this problem, I ran the SLXProfiler.exe tool in the C:\Program Files\SalesLogix folder. Start it right before you open an opportunity, and then pause it right after the opportunity finishes opening - and look down through the "Execute(ms)" column - look for the really high numbers, and you can identify which SQL statements are the really slow ones.
When I ran the profiler and opened an Opportunity, I found that the Notes/History tab was killing the speed - through the profiler I found that the grid in the tab was pulling almost a million history records before it ran again and pulled the right ones! I started a thread on what I found: http://www.slxdeveloper.com/forum.aspx?forumid=2000&postid=11949
Anyway, I hope all that made sense. The profiler is the best way to answer your question, so good luck! |
|
|
|
Re: Opportunity Performance issue
Posted: 05 Dec 07 9:35 AM
|
Thanks everyone for all your help.
fixed this issue. Created index on SALESPROCESSAUDIT.SALESPROCESSID
voila.... system came beck to normal speed.. users are happy... |
|
|
|