topic Re: rsdb/max_blocking_factor in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212473#M1006618 <HTML><HEAD></HEAD><BODY><P>Split factor for FOR ALL ENTRIES queries</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="631728"></A></P></BODY></HTML> Wed, 16 Jul 2008 11:41:56 GMT Former Member 2008-07-16T11:41:56Z rsdb/max_blocking_factor https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212472#M1006617 <HTML><HEAD></HEAD><BODY><P>What is rsdb/max_blocking_factor?</P></BODY></HTML> Wed, 16 Jul 2008 11:37:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212472#M1006617 Former Member 2008-07-16T11:37:39Z Re: rsdb/max_blocking_factor https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212473#M1006618 <HTML><HEAD></HEAD><BODY><P>Split factor for FOR ALL ENTRIES queries</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="631728"></A></P></BODY></HTML> Wed, 16 Jul 2008 11:41:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212473#M1006618 Former Member 2008-07-16T11:41:56Z Re: rsdb/max_blocking_factor https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212474#M1006619 <HTML><HEAD></HEAD><BODY><P>"The for all entries creates a where clause, where all the entries in the driver table are combined with OR. If the number of entries in the driver table is larger than rsdb/max_blocking_factor, several similar SQL statements are executed to limit the length of the WHERE clause.</P><P></P><P>For example: you have 100 conditions generated by FOR ALL ENTRIES statement, the parameter is 5, then, the select statement is divided into 20 select sql with 5 conditions in where clause in each sql.</P><P></P><P>It is related to the performance of FOR ALL ENTRIES.</P><P></P><P>But not the larger the better. You can try, and it depends or your server machine.</P></BODY></HTML> Fri, 18 Jul 2008 10:42:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/rsdb-max-blocking-factor/m-p/4212474#M1006619 Former Member 2008-07-18T10:42:18Z