What are the implications/advantages/drawbacks of the “Automatically determine the number of cases” option?
When the number of cases is not known and an analysis requires that information, then when this method is in effect a separate, ‘count’ query will be executed, and the analysis will have to wait on the result. If the query is complicated, this can be slow. In addition, if changes have been made to the database between the time you first executed your original query and when the ‘count’ query is executed, the results can be inconsistent; i.e., if someone else added or deleted records then the number of records in your cursor will not match the number of records reported to the analysis. The advantage is, if the query is not too complicated and the database has not been changed, this gives you an exact case count without having to resort to a slower cursor type that would always have that information.
Related Questions
- I am using the option to Automatically Detect the Presence of Handwriting for my Image field. Why isn Remark Office OMR picking up all of my handwritten comments?
- What are the implications/advantages/drawbacks of the "Automatically determine the number of cases" option?
- What are the implications/advantages/drawbacks of the "Assume fewer than [x] number of cases" option?