---
title: "Conversion Attributes"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/conversion/attributes
original: https://documentation.invantive.eu/en/datamodels/conversion/attributes
updated: 2026-11-16T20:43:02Z
license: https://documentation.invantive.eu/es/
---

# Conversion Attributes

## Comportamiento

### force-case-sensitive-identifiers

Considere los identificadores como sensibles a mayúsculas y minúsculas, independientemente de las capacidades de la plataforma.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### forced-casing-identifiers

Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### group-by-pushdown-max-groups

Maximum number of groups a data container may answer to a pushed group by before the rows are read instead. Zero switches the push off.

- Valor predeterminado: `1000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-compress-sparse-arrays

Si se deben comprimir matrices dispersas en los conjuntos de resultados durante la compresión.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-correct-invalid-date

Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-child-exists-filters-to-data-containers

El contenedor de datos evalúa, siempre que sea razonablemente posible, si existe un filtro relativo a la existencia de una fila relacionada, de modo que las filas se descarten antes de ser transferidas.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-filters-to-data-containers

Si se deben reenviar los filtros a los contenedores de datos.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-projections-to-data-containers

Siempre que sea razonablemente posible, solo se solicitan al contenedor de datos aquellas columnas que la instrucción utiliza realmente, lo que reduce el volumen de datos transferidos.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-projections-to-synchronize-target

La tabla en la que se sincronizan las escrituras se lee únicamente en las columnas que se comparan, que son aquellas presentes en ambos lados, en lugar de en todas ellas.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-share-byte-arrays

Si se debe compartir la memoria utilizada por matrices de bytes idénticas en los conjuntos de resultados durante la compresión.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-share-strings

Si se debe compartir la memoria utilizada por cadenas idénticas en los conjuntos de resultados durante la compresión.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-shuffle-fetch-results-data-containers

Si se deben mezclar o no los resultados obtenidos de los contenedores de datos.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### max-length-identifiers

Longitud máxima no predeterminada en caracteres de los nombres de los identificadores.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### partition-slot-based-rate-limit-length-ms

Duración total en milisegundos en todas las ranuras de un límite de velocidad basado en particiones.

- Valor predeterminado: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### pre-request-delay-ms

Retraso previo a la solicitud en milisegundos por solicitud.

- Valor predeterminado: `0`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### requested-maximum-usable-partitions

Número máximo de particiones utilizables solicitado

- Set from: connection string, set statement, provider file
- Defined by: Shared

### slot-based-rate-limit-length-ms

Duración total en milisegundos en todas las franjas de un límite de velocidad basado en franjas horarias.

- Valor predeterminado: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### standardize-identifiers

Vuelva a escribir todos los identificadores según los estándares preferidos configurados por los identificadores estandarizados en mayúsculas y minúsculas de los identificadores de longitud máxima.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### standardize-identifiers-casing

Vuelva a escribir todos los identificadores en la carcasa estándar recomendada específica de la plataforma al cambiar un modelo de datos en una plataforma que depende del caso.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

## Almacenamiento en Caché

### invantive-use-cache

Si almacenar en la memoria caché los resultados de una consulta.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

## Diagnósticos

### analysis-enforce-row-uniqueness

Enforce rows to be unique for software analysis. A fingerprint is calculated from the whole row of data when the primary key column is unknown.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-execution-profile-disk-file-name

Nombre del archivo en el que se guardará el perfil de ejecución de las instrucciones.

- Valor predeterminado: `profile-{date}-{applicationname}-{currentprocessid}-{sessionid}.ndjson`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-execution-profile-disk-path

Carpeta en la que se guardará el perfil de ejecución de las instrucciones.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-execution-profile-to-disk

Si se debe escribir en disco el perfil de ejecución de las instrucciones.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### log-native-calls-to-disk-max-events

Número máximo de eventos de llamada a registrar desde la última activación.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-max-sec

Número máximo de segundos para registrar llamadas desde la última activación.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-on-error

Registra las llamadas nativas al backend del contenedor de datos como archivos de disco cuando la llamada genera un error.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-on-success

Registra las llamadas nativas al backend del contenedor de datos como archivos de disco cuando la llamada no genera ningún error.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-trace

Registra las llamadas nativas en el backend del contenedor de datos durante el rastreo.

- Valor predeterminado: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

## Rendimiento

### bulk-delete-page-size-rows

Número de filas que se van a eliminar por lote cuando se realiza una eliminación masiva.

- Valor predeterminado: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-bytes

Tamaño máximo aproximado en bytes de lote cuando se inserta de forma masiva.

- Valor predeterminado: `10000000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-rows

Número de filas para insertar por lote cuando se inserta de forma masiva.

- Valor predeterminado: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-psql-max-parallel

Maximum degree of the PSQL parallel constructs: session default and cap for every parallel statement or loop without an explicit degree. The value 1 runs every parallel construct sequentially with unchanged semantics.

- Valor predeterminado: `48`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading

Whether data which the session is expected to ask for shortly may be fetched while the session is idle. What that may cost is governed by the settings below, and it stops the moment the session asks for something itself.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-blobs-per-minute

Number of file contents, such as document attachments, which may be fetched ahead per minute. Most platforms do not count these against their request rate, so they pace themselves.

- Valor predeterminado: `20`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-daily-reserve-fraction

Parte de la asignación diaria de una plataforma que nunca se destina a la recuperación anticipada, de modo que una sesión conserve margen para el resto de la jornada.

- Valor predeterminado: `0,4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-disk-budget-mb

Número de megabytes que la recuperación anticipada puede escribir en las cachés locales de este usuario.

- Valor predeterminado: `8192`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-first-use-rows

Number of rows fetched of each table in a session for which no history of earlier questions is available. A first look at a table shows a few hundred rows, and having those ready is what makes it feel instant.

- Valor predeterminado: `1000`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-horizon-min

Número de minutos por delante durante los cuales se evalúa la probabilidad de que se solicite una tabla.

- Valor predeterminado: `60`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-idle-scope-data-container

Whether only the traffic of the same data container counts as the session being busy, rather than all traffic of the session. Suits a script, which is nearly always busy on one platform while its next step reads another.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-idle-sec

Número de segundos que una sesión debe permanecer inactiva antes de que se recuperen datos de forma anticipada y antes de que se reanude la recuperación de datos tras una solicitud de la sesión.

- Valor predeterminado: `5`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-journal

Whether the history of earlier questions of this user is used to decide what to fetch ahead. Switched off, only what the drivers propose and what is announced is used.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-linger-sec

Número de segundos que un servidor mantiene una sesión después de que su usuario se haya desconectado, siempre y cuando la carga de trabajo de la recuperación anticipada lo permita dentro de los límites establecidos.

- Valor predeterminado: `900`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-max-parallel

Número de tablas que se pueden recuperar por adelantado al mismo tiempo en una misma conexión.

- Valor predeterminado: `4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-max-unattended-sec

Número de segundos sin que se haya formulado ninguna pregunta durante la sesión, tras los cuales se detiene la recuperación anticipada hasta que la sesión vuelva a formular una pregunta.

- Valor predeterminado: `7200`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-node-max-parallel

Número de tablas que esta instalación puede precargar al mismo tiempo, en todas las sesiones a las que da servicio.

- Valor predeterminado: `4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-partitions

Codes of the partitions, separated by commas, on which fetching ahead may work. Left empty, it works on every partition the session has selected.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-rate-fraction

Part of the minutely request rate of a platform, per partition, which may be spent on fetching ahead. The remainder stays free for what the session asks itself.

- Valor predeterminado: `0,75`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-serve-stale-max-age-sec

Age in seconds up to which a question about a table which is held locally is answered from what is held, without asking the platform for the changes since. The local copy is brought up to date behind the answer, so the next question sees them. Empty, which is the default, always asks.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-superset

Si una consulta con un filtro puede responderse a partir de una tabla que esta sesión ya ha recuperado en su totalidad, en lugar de pedir a la plataforma que aplique el filtro.

- Valor predeterminado: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-superset-max-rows

Number of rows up to which a question with a filter is answered from a set which this session already fetched whole, instead of asking the platform to apply the filter. Above it the platform is asked, since walking a large set locally costs more than a call which returns a fraction of it.

- Valor predeterminado: `250000`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### requested-page-size

Número preferido de filas para intercambiar por viaje de ida y vuelta; solo es válido en plataformas limitadas, como AFAS Online.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### requests-parallel-max

Número máximo de solicitudes de datos en paralelo de particiones individuales en el contenedor de datos.

- Valor predeterminado: `32`
- Set from: connection string, set statement, provider file
- Defined by: Shared


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

- [Conversion](/es/release-notes/drivers?driver=conversion)
