[spratzt]

You certainly won’t hit it with most corporate OLAP processing, which is nearly all read-only SQlite. Writes are generally batched and processed outside ‘normal’ business hours, where the limitations of SQlite writing are irrelevant.

[andai]

Where are they batched?

[chatmasta]

In a separate system maintained by the DuckDB cargo cultists.