<html dir="ltr"><head></head><body style="text-align:left; direction:ltr;"><div>Am Montag, dem 17.01.2022 um 20:10 +1100 schrieb Zoltan Somogyi:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><pre>2022-01-17 20:00 GMT+11:00 "Volker Wysk" <<a href="mailto:post@volker-wysk.de">post@volker-wysk.de</a>>:</pre><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><pre>This explains why there's only one transcation per connection, but it's</pre><pre>completely contrary to what I've heard. AFAIK opening a connection is an</pre><pre>expensive operation...</pre></blockquote><pre><br></pre><pre>Take a look at the git history of extras/odbc.m. It was added in 1997,</pre><pre>and even then, it was not new. I would be extremely surprised if</pre><pre>the tradeoff remained the same over the last quarter of a century ...</pre><pre><br></pre><pre>Specifically, at that time, virtually all database operations required</pre><pre>one or more disk accesses, because of the (by today's standards)</pre><pre>tiny amount of main memory available. These disk accesses took</pre><pre>much more time than connection setup/teardown, which did *not*</pre><pre>require disk access.</pre></blockquote><div><br></div><div>You always have the perfect answer. :-)</div><div><br></div><div>I've taken a look at the implementation in odbc.m. It looks like it would be rather trivial to modify it, such that connections would be opened and closed explicitly. In case I really need this.</div><div><br></div><div>Cheers, Volker<font size="2"></font></div></body></html>