Administration Features and Functions > Browse Performance Controls > Browse Initial Database Query Suppression
  
Browse Initial Database Query Suppression
By default, browses run with an initial database query, which can cause performance issues with some browses. To improve performance, you can configure whether browses run with an initial database query. You can suppress the initial query for all browses or just specified browses. If you suppress all browses, you can then specify exceptions, allowing only specified browses to run with an initial database query. To configure the system, use the following settings in the client session configuration file (client-session.xml):
<Browse>
<!-- Browse specific override -->
<override>
<suppressinitialload>
<!-- To suppress browse launch for specific browses
enter the browseid in the suppressinitialload section.
Use "*" to suppress all
-->
<!--
<id>pp100</id>
<id>gp340</id>
-->
</suppressinitialload>
<doinitialload>
<!-- If "*" used above, allow specific browses to load -->
<!--
<id>mg003</id>
-->
</doinitialload>
</override>
</Browse>
In <suppressinitialload>, list the IDs of browses whose initial database query you want to suppress or use an asterisk (*) to suppress the initial database query of all browses. If you suppress all, you can then specify exceptions in <doinitialload>, where you list the IDs of browses that you want to run with an initial database query.
Examples
To suppress all browses:
<suppressinitialload>
<all id="*"/>
</suppressinitialload>
To suppress Item Browse (pp100) and Sales Order Browse (so009):
<suppressinitialload>
<id>pp100</id>
<id>so009</id>
</suppressinitialload>
To suppress all browses except Item Browse (pp100), Sales Order Browse (so009), and Supplier View (BCreditor.View):
<suppressinitialload>
<all id="*"/>
</suppressinitialload>
<doinitialload>
<do id="pp100"/>
<do id="so009"/>
<do id="BCreditor.View"/>
</doinitialload>