7/5/2025 9:30:14 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Too many users for Owner Lookup?
Posted: 18 Aug 09 1:11 PM
|
Hi all
We're currently developing two 7.5.1 systems in tandem, "upgrading" from 6.2 (the only thing actually staying the same is the DB, and only just). They're similar systems, so we're able to borrow between the two. However, I've got a problem on the TicketDetails quickform with the AssignedTo control (which uses an Owner lookup).
For some strange reason one of them just refuses to show any users, but only shows Teams and the System owners (i.e. Everyone etc.) the only difference I can think of is that the system that isn't working has over 590 active users. Could this be the cause?
As an alternative, we're looking at either a dropdown list, which is a bit lame and will probably cause an overhead at having to be populated every time the form is loaded, or a brand spanking new dialog (probably equipped with a listbox or something).
Any ideas or suggestions would be greatly appreciated.
David |
|
|
|
Re: Too many users for Owner Lookup?
Posted: 18 Aug 09 3:12 PM
|
I've not seen that happen before, but not sure I've tested that on a system with that many users yet either. I would think it would handle that many users, but who knows. Maybe try running profiler to see if there is anything weird going on?
As far as work-arounds, I would just use a Lookup instead of a drop-down or new custom dialog. This way, the user can search and it doesn't need to load all the data when the form loads.
-Ryan |
|
|
|
Re: Too many users for Owner Lookup?
Posted: 19 Aug 09 4:33 AM
|
Brilliant! Don't know why I didn't think of that!
Are you talking SQL Profiler? Forgive my ignorance, I'm still a bit of a beginner in some respects!
Cheers |
|
|
|
Re: Too many users for Owner Lookup?
Posted: 19 Aug 09 6:04 AM
|
I ran a SQL Profiler Trace just whilst I was opening the Owner lookup and trying to expand the Users list and incredibly the trace seems to suggest that each record is opened individually. Instead of doing a select... from... it's doing a select... from... where seccodeid = xxx for each individual owner.
The error message I receive on the front end is similar to ones you occassionally get on big groups, and seems to relate to jQuery. Could it be that SLX loads each user in turn? |
|
|
|
Re: Too many users for Owner Lookup?
Posted: 19 Aug 09 6:11 AM
|
David:
I ran into this issue both on 6.2 and 7.5
We had several thousand users on a system and we had to customize the system to use Lookup Controls instead of the User and Owner controls to Improve performance.
In our case, each page that contained any User Lookup (rendered as a drop down by default) was taking a long time to load and on top of that it was increasing the footprint of each page being accessed.
Our solution as well was to utilize Lookup controls instead. |
|
|
|
Re: Too many users for Owner Lookup?
Posted: 19 Aug 09 6:16 AM
|
I think it's safe to say that it's due to numbers then.
I'm just in the process of replacing with a lookup.
Thanks for the confirmation and the advice! |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|