M2M queries
Hi All,
When i am running M-M relationship query for less number records(Eg: less than 6M in my local machine) are getting output but for greater than 6M records,after 3 to 4 mins,it is saying query error.
But i got some document from team lead to change to properties of M2M part mentioned like below
from below path C:\Program Files\Sisense\Prism\Server\Abacus64BD\bin but still i am not getting warning if we have records more than 7M simply saying, Query error.
m2m_detect_build_result_increase_percent=1000
m2m_detect_build_result_increase_size=10000000
m2m_detect_error_result_increase_percent=1000
m2m_detect_error_result_increase_size=10000000
m2m_detect_warning_result_increase_percent=500
m2m_detect_warning_result_increase_size=7000000
m2m_detect_sample_power_2_interval=20
m2m_minimum_estimate_value=10000000
Please sign in to leave a comment.
Comments
0 comments