The Web UI is becoming very sluggish to the extent that it is becoming ususable. Investigation is showing that the w3wp.exe process (in task manager) is running at high levels. In extreme circumstances Internet Explorer is unresponsive, and when the user tries to log in again, the logon page does not appear.
If you have issues like this please raise a service ticket, as there may be several reasons.
However, in this example it seemed that users were setting their 'Maximum rows in search results' preferences to extremely high values. The following SQL, run directly on the database will list all users with 'Maximum rows in search results' greater than 2000.
select u.user_id,s.value from settings sinner join users u on u.person_id=s.object_idwhere setting_id IN (select setting_id from setting_defs where code = 'MaxRowsToReturn' and object_type = 4) and value > 2000
to force users preferences back to 800, run the following SQL:
dbo.ebp_set_setting 'MaxRowsToReturn', 1,4, '800', 'Y', 1
Bentley would not recommend this value to be in excess of 2000. This setting specifies the page size used when an eB client displays results, the search engine allows the user to page through the set of hits returned and uses this as the block size. Making this very large results in increased memory pressure on the application server (packaging the results) and on the client (unpacking the results and creating an output table). Paging through a number of smaller pages is faster than setting the size large and assuming that you can scroll through the results.
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!