Voltar
-
Título
Add configuration for VI.DB ISqlFormatter.InClauseLimit. -
Descrição
VI.DB ISqlFormatter.InClauseLimit has been changed from 8000 to 1024. The limit has been lowered to avoid problems with the SQL Query Planner: the high value could cause errors and timeouts. However the lower value is causing pre-configured searches for some customers now to fail. -
Causa
The value of 1024 should be adequate for most needs. If thousands of results are being returned in a search then it is advised to use filters or more precise search terms. -
Resolução
An enhancement request (#461827) has been created to make this value configurable. The Product team will evaluate whether this can be included in a future release of the product. -
Solicitação de alteração
461827