George
Is it possible that you have a single reference on an object set to "drop down" that has "Fetch all records at once" set ?
(I once had a similar problem that manifested over time where a product object grew to thousands of records and whenever multiple users clicked on the drop down, thousands of records were loaded into memory multiple times using up all memory space resulting in hanging)
It sure would be interesting & helpful to develop a list of potential config tool "warning" conditions that could be displayed for a BSV.
Let's say you have two attributes that have a "drop down" setting as ACDC described above .. one that makes total sense and the other that has grown out of control. In a perfect world, I'd love to be a list of these potential design concerns on a screen with the ability to flag the conditions you don't want to continue to display time after time. Of course, you would also need the ability to see the entire list (including items you have previously flagged to no longer display) so that you would have the ability to do perhaps an annual deep dive into a BSV for potential design concerns.
The Cadillac version of a tool like this would allow a menu option in an operational BSV (for BSV designers to use) that actually looked at conditions in the database (in this case # of records in a particular "fetch all records at once" drop down) and show a list of concerns for potential action.
