odbc icon indicating copy to clipboard operation
odbc copied to clipboard

Published 20 hours ago • verified publisher icon r-dbi

Asynchronous operation

Open krlmlr opened this issue 4 years ago • 1 comments

It would be great to be able to interrupt a query that takes a long time to run and return records. For this it seems we need to look into asynchronous execution with polling: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/asynchronous-execution-polling-method?redirectedfrom=MSDN&view=sql-server-ver15 .

A first glance into nanodbc suggests that some form of callback is supported. For drivers that support this, we could then execute asynchronously and poll for completion and also call checkUserInterrupt().

krlmlr avatar Oct 28 '19 09:10 krlmlr

https://github.com/r-dbi/RPostgres/pull/193 contains an implementation for libpq, we could model after this, including the argument name.

krlmlr avatar Dec 17 '19 12:12 krlmlr

Tracking in #433

hadley avatar Apr 24 '23 15:04 hadley