[m-users.] ODBC library: Ony one transaction per connection .. ?

[Zoltan Somogyi]

2022-01-17 20:00 GMT+11:00 "Volker Wysk" <post at volker-wysk.de>:
> This explains why there's only one transcation per connection, but it's
> completely contrary to what I've heard. AFAIK opening a connection is an
> expensive operation...

Take a look at the git history of extras/odbc.m. It was added in 1997,
and even then, it was not new. I would be extremely surprised if
the tradeoff remained the same over the last quarter of a century ...

Specifically, at that time, virtually all database operations required
one or more disk accesses, because of the (by today's standards)
tiny amount of main memory available. These disk accesses took
much more time than connection setup/teardown, which did *not*
require disk access.

Zoltan.