So for a great many workloads, particularly multi-user, SQLite will be faster overall, as most application workloads will have many simple single/few row lookup operations per single/few row update operations, and an order of magnitude less complex analytical queries.
But this should be much faster for genuine analytical operations, and better suited to them due to support for things like temporal storage and queries.
Basically the age-old distinction between optimising for OLTP or OLAP operations.
I guess I'm a bit confused but don't want to read AI fuzz further
NAPI-RS has no serialisation overhead?