---
title: "Release notes of In-Memory Storage"
description: "What changed in the drivers of Invantive UniversalSQL per release: tables, columns, attributes and capabilities, and what to change in statements and connection strings."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/drivers?driver=in-memory-storage
---

# Release notes of In-Memory Storage

**Drivers:** [ActiveCampaign](/en/release-notes/drivers.md?driver=activecampaign&driver=in-memory-storage) | [Autotask](/en/release-notes/drivers.md?driver=autotask&driver=in-memory-storage) | [Bouw7](/en/release-notes/drivers.md?driver=bouw7&driver=in-memory-storage) | [Brevo](/en/release-notes/drivers.md?driver=brevo&driver=in-memory-storage) | [Calendly](/en/release-notes/drivers.md?driver=calendly&driver=in-memory-storage) | [CBS](/en/release-notes/drivers.md?driver=cbs&driver=in-memory-storage) | [Chargebee](/en/release-notes/drivers.md?driver=chargebee&driver=in-memory-storage) | [CompanyInfo](/en/release-notes/drivers.md?driver=companyinfo&driver=in-memory-storage) | [Conversion](/en/release-notes/drivers.md?driver=conversion&driver=in-memory-storage) | [Crisp](/en/release-notes/drivers.md?driver=crisp&driver=in-memory-storage) | [Data Cache](/en/release-notes/drivers.md?driver=data-cache&driver=in-memory-storage) | [Data Dictionary](/en/release-notes/drivers.md?driver=data-dictionary&driver=in-memory-storage) | [Discourse](/en/release-notes/drivers.md?driver=discourse&driver=in-memory-storage) | [Dummy](/en/release-notes/drivers.md?driver=dummy&driver=in-memory-storage) | [Easyflex](/en/release-notes/drivers.md?driver=easyflex&driver=in-memory-storage) | [ECB Exchange Rates](/en/release-notes/drivers.md?driver=ecb-exchange-rates&driver=in-memory-storage) | [Exact Online](/en/release-notes/drivers.md?driver=exact-online&driver=in-memory-storage) | [Fortnox](/en/release-notes/drivers.md?driver=fortnox&driver=in-memory-storage) | [Freshdesk](/en/release-notes/drivers.md?driver=freshdesk&driver=in-memory-storage) | [Freshservice](/en/release-notes/drivers.md?driver=freshservice&driver=in-memory-storage) | [Gripp CRM](/en/release-notes/drivers.md?driver=gripp-crm&driver=in-memory-storage) | [Horeko](/en/release-notes/drivers.md?driver=horeko&driver=in-memory-storage) | [HubSpot](/en/release-notes/drivers.md?driver=hubspot&driver=in-memory-storage) | **[In-Memory Storage](/en/release-notes/drivers.md)** (chosen) | [ionBIZ](/en/release-notes/drivers.md?driver=in-memory-storage&driver=ionbiz) | [Kadaster](/en/release-notes/drivers.md?driver=in-memory-storage&driver=kadaster) | [KeePass](/en/release-notes/drivers.md?driver=in-memory-storage&driver=keepass) | [Knack](/en/release-notes/drivers.md?driver=in-memory-storage&driver=knack) | [KOOP (NL) BWB](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-bwb) | [KOOP (NL) CVDR](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-cvdr) | [KOOP (NL) Europese Richtlijnen](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-europese-richtlijnen) | [KOOP (NL) Officiele Publicaties](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-officiele-publicaties) | [KOOP (NL) PLOOI](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-plooi) | [KOOP (NL) PUC Open Data](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-puc-open-data) | [KOOP (NL) Samenwerkende Catalogi](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-samenwerkende-catalogi) | [KOOP (NL) Staatsalmanak](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-staatsalmanak) | [KOOP (NL) Staten Generaal Digitaal](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-staten-generaal-digitaal) | [KOOP (NL) Tuchtrecht](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-tuchtrecht) | [KOOP (NL) Verdragenbank](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-verdragenbank) | [KOOP (NL) Wetgevingskader](/en/release-notes/drivers.md?driver=in-memory-storage&driver=koop-nl-wetgevingskader) | [Localazy](/en/release-notes/drivers.md?driver=in-memory-storage&driver=localazy) | [LogiusCor](/en/release-notes/drivers.md?driver=in-memory-storage&driver=logiuscor) | [Loket.nl REST](/en/release-notes/drivers.md?driver=in-memory-storage&driver=loket-nl-rest) | [Mail](/en/release-notes/drivers.md?driver=in-memory-storage&driver=mail) | [Minox](/en/release-notes/drivers.md?driver=in-memory-storage&driver=minox) | [Mollie](/en/release-notes/drivers.md?driver=in-memory-storage&driver=mollie) | [Nmbrs](/en/release-notes/drivers.md?driver=in-memory-storage&driver=nmbrs) | [Odoo](/en/release-notes/drivers.md?driver=in-memory-storage&driver=odoo) | [Open Exchange Rates](/en/release-notes/drivers.md?driver=in-memory-storage&driver=open-exchange-rates) | [OpenArch](/en/release-notes/drivers.md?driver=in-memory-storage&driver=openarch) | [OpenSpending](/en/release-notes/drivers.md?driver=in-memory-storage&driver=openspending) | [OS](/en/release-notes/drivers.md?driver=in-memory-storage&driver=os) | [Outlook](/en/release-notes/drivers.md?driver=in-memory-storage&driver=outlook) | [Postman](/en/release-notes/drivers.md?driver=in-memory-storage&driver=postman) | [RDW](/en/release-notes/drivers.md?driver=in-memory-storage&driver=rdw) | [ROBAWS](/en/release-notes/drivers.md?driver=in-memory-storage&driver=robaws) | [Roller](/en/release-notes/drivers.md?driver=in-memory-storage&driver=roller) | [Simplicate](/en/release-notes/drivers.md?driver=in-memory-storage&driver=simplicate) | [SnelStart](/en/release-notes/drivers.md?driver=in-memory-storage&driver=snelstart) | [Teamleader Focus](/en/release-notes/drivers.md?driver=in-memory-storage&driver=teamleader-focus) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=in-memory-storage&driver=teamleaderorbit) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=in-memory-storage&driver=teamleader-orbit) | [Tixly](/en/release-notes/drivers.md?driver=in-memory-storage&driver=tixly) | [Tweede Kamer](/en/release-notes/drivers.md?driver=in-memory-storage&driver=tweede-kamer) | [Tweede Kamer NL](/en/release-notes/drivers.md?driver=in-memory-storage&driver=tweede-kamer-nl) | [Twinfield](/en/release-notes/drivers.md?driver=in-memory-storage&driver=twinfield) | [Visma Severa](/en/release-notes/drivers.md?driver=in-memory-storage&driver=visma-severa) | [Visma.net Financials](/en/release-notes/drivers.md?driver=in-memory-storage&driver=visma-net-financials) | [Visual FoxPro](/en/release-notes/drivers.md?driver=in-memory-storage&driver=visual-foxpro) | [Wikipedia](/en/release-notes/drivers.md?driver=in-memory-storage&driver=wikipedia) | [Yuki](/en/release-notes/drivers.md?driver=in-memory-storage&driver=yuki)

**Releases:** [26.0 to 27.0](/en/release-notes/drivers.md?driver=in-memory-storage&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/drivers.md?driver=in-memory-storage&step=new-in-27.0)

<div class="rn-block" id="in-memory-storage-26.0-to-27.0">

<div class="rn-head">

Driver Release Note - Internal

## In-Memory Storage driver 27.0, from 26.0

| Build | Date | Description |
|---|---|---|
| `26.0.4` | 22-03-2026 | first build of release 26.0 |
| `27.0.93` | 10-11-2026 | latest build of release 27.0 at the time of writing |

The older end is the first build of release 26.0, not its last, because later builds of 26.0 received ports of changes made for 27.0. The data model of a release is the model that a later build of the same release generated.

- **5** changes
- **0** can break a statement
- **3** groups not available

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [By Group](#in-memory-storage-26.0-to-27.0-groups)
- [Before You Upgrade](#in-memory-storage-26.0-to-27.0-before)
- [Top 5 Changes](#in-memory-storage-26.0-to-27.0-top)

**Groups**

- [Data model](#in-memory-storage-26.0-to-27.0-g-data_model)
- [Provider attributes](#in-memory-storage-26.0-to-27.0-g-provider_attributes)
- [Capabilities](#in-memory-storage-26.0-to-27.0-g-capabilities)
- [Performance](#in-memory-storage-26.0-to-27.0-g-performance) 2
- [Bug fixes](#in-memory-storage-26.0-to-27.0-g-bug_fixes) 2
- [Enhancements](#in-memory-storage-26.0-to-27.0-g-enhancements) 1
- [Log-on and platform](#in-memory-storage-26.0-to-27.0-g-authentication_platform) 0

**More**

- [More Information](#in-memory-storage-26.0-to-27.0-more)

</div>

<div class="rn-main">

<a id="in-memory-storage-26.0-to-27.0-groups"></a>

### What Changed, by Group

Every change is in one group: the group answers the question that you ask before you upgrade.

<div class="rn-cards">

- [Data model](#in-memory-storage-26.0-to-27.0-g-data_model)
  - &ndash;
  - *not available*
  - Do my statements and views still work?
- [Provider attributes](#in-memory-storage-26.0-to-27.0-g-provider_attributes)
  - &ndash;
  - *not available*
  - Do I have to change my connection string, provider file or settings?
- [Capabilities](#in-memory-storage-26.0-to-27.0-g-capabilities)
  - &ndash;
  - *not available*
  - What can the driver do with a table?
- [Performance](#in-memory-storage-26.0-to-27.0-g-performance)
  - 2
  - Is it faster, and does it call the platform less?
- [Bug fixes](#in-memory-storage-26.0-to-27.0-g-bug_fixes)
  - 2
  - Is the defect that I met repaired?
- [Enhancements](#in-memory-storage-26.0-to-27.0-g-enhancements)
  - 1
  - What can I do now that I could not?
- [Log-on and platform](#in-memory-storage-26.0-to-27.0-g-authentication_platform)
  - 0
  - Do I have to log on again, or change something because of the platform?

</div>

[Download Changes as CSV](/en/release-notes/drivers/in-memory-storage/26.0-to-27.0.csv)

<div class="rn-before" id="in-memory-storage-26.0-to-27.0-before">

### Before You Upgrade

The data models of this step could not be compared, so changes of tables and columns that break a statement are not known. The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

No other change of this step is marked as breaking.

</div>

<a id="in-memory-storage-26.0-to-27.0-top"></a>

### Top 5 Changes

Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.

<div class="rn-top">

1. [CREATE TABLE in the in-memory driver uses less memory](#IMY-27.0-P001)
   - *Performance*
   - Importance 3 of 5.
2. [In-memory tables are safe for concurrent use and deletes, updates and inserts are faster](#IMY-27.0-P002)
   - *Performance*
   - Importance 3 of 5.
3. [CREATE TABLE in the in-memory driver reports success after creating the table](#IMY-27.0-B001)
   - *Bug fixes*
   - Importance 2 of 5.
4. [Rows and size of reads and writes of the in-memory driver are registered correctly](#IMY-27.0-B002)
   - *Bug fixes*
   - Importance 2 of 5.
5. [A statement on an in-memory table can be cancelled while rows are being read](#IMY-27.0-E001)
   - *Enhancements*
   - Importance 2 of 5.

</div>

<a id="in-memory-storage-26.0-to-27.0-g-data_model"></a>

### Data model

Do my statements and views still work? Tables, views, table functions, columns, parameters, keys, code values, packages and procedures that appear, disappear, are renamed or change type.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="in-memory-storage-26.0-to-27.0-g-provider_attributes"></a>

### Provider attributes

Do I have to change my connection string, provider file or settings? Attributes of the connection and settings of the driver that appear, disappear or change default or place where they can be set.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="in-memory-storage-26.0-to-27.0-g-capabilities"></a>

### Capabilities

What can the driver do with a table? Whether a table or table function can be selected from, inserted into, updated and deleted from.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="in-memory-storage-26.0-to-27.0-g-performance"></a>

### Performance

Is it faster, and does it call the platform less? Paging, batching, caching, filters and projections sent to the platform, fewer requests, less memory.

<div class="rn-chips">

- 2 changes
- commits

</div>

<div class="rn-item" id="IMY-27.0-P001">

##### CREATE TABLE in the in-memory driver uses less memory

Creating an in-memory table from a result set no longer builds a full second copy of the rows first. Rows are taken in batches into a table that other statements do not see yet, and the table replaces its predecessor only when it is complete. A create of a large table registers its inserts as bulk inserts.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="IMY-27.0-P002">

##### In-memory tables are safe for concurrent use and deletes, updates and inserts are faster

Every in-memory table now has its own read and write lock, so parallel branches of a statement can read and change a table without damaging it. A row is removed in constant time instead of rebuilding the indexes after each delete, so a volume delete is no longer quadratic in the size of the table. An update replaces the row as a whole, so a reader never sees a half-updated row, and new rows are added to the existing indexes instead of invalidating them.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<a id="in-memory-storage-26.0-to-27.0-g-bug_fixes"></a>

### Bug fixes

Is the defect that I met repaired? Wrong or missing rows, wrong values, crashes and wrong messages, repaired in a release line that had the defect.

<div class="rn-chips">

- 2 changes
- commits

</div>

<div class="rn-item" id="IMY-27.0-B001">

##### CREATE TABLE in the in-memory driver reports success after creating the table

After a table was created the driver answered that it was not capable, which is the answer for a table that could not be created. It now answers that the call was successful.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="IMY-27.0-B002">

##### Rows and size of reads and writes of the in-memory driver are registered correctly

A create of an in-memory table registered only the size of its name and no rows, and a limited read registered the size of the whole table. The registrations now carry the rows and the estimated size that were really moved.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="in-memory-storage-26.0-to-27.0-g-enhancements"></a>

### Enhancements

What can I do now that I could not? New functions and options that are not a table or a column.

<div class="rn-chips">

- 1 changes
- commits

</div>

<div class="rn-item" id="IMY-27.0-E001">

##### A statement on an in-memory table can be cancelled while rows are being read

Reading a large stored result from an in-memory table did not check for cancellation, so a cancelled statement kept running until all rows were cloned. The check now takes place for every row.

<div class="rn-chips">

- importance 2
- confidence high

</div>

</div>

<a id="in-memory-storage-26.0-to-27.0-g-authentication_platform"></a>

### Log-on and platform

Do I have to log on again, or change something because of the platform? Log-on and token handling, scopes and permissions, a new version of the platform API, retired endpoints and changed limits.

<div class="rn-chips">

- 0 changes
- commits

</div>

No changes in this group.

<a id="in-memory-storage-26.0-to-27.0-more"></a>

### More Information

- [Data model documentation of the driver](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/)
- [Invantive Cloud page of the driver](https://cloud.invantive.com/dummy)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- Commit items were classified by one reader; the model changes are derived and need no reading.
- Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
- Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
- A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
- 7 links between a change and a source commit are recorded.

</div>

</div>

</div>

</div>

