Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

rsdb/max_blocking_factor

Go to solution
Former Member

‎2008 Jul 16 12:37 PM

0 Likes
728

What is rsdb/max_blocking_factor?

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Jul 16 12:41 PM

0 Likes
551

Split factor for FOR ALL ENTRIES queries

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Jul 16 12:41 PM

0 Likes
552

Split factor for FOR ALL ENTRIES queries

Read only

Go to solution
Former Member

‎2008 Jul 18 11:42 AM

0 Likes
551

"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.

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.

It is related to the performance of FOR ALL ENTRIES.

But not the larger the better. You can try, and it depends or your server machine.