Thread: asynchronous execution

Hi,

Are there any work done, or plans for implementing asynchronous
execution in psqlodbc?

Does anyone have an idea if this is difficult to implement?

Does libpq support asynchronous calls?


Greetings,

Tomas

> Are there any work done, or plans for implementing asynchronous
> execution in psqlodbc?

Not sure about future plans, but there is nothing stopping you from opening thread in your app and running odbc call
thatway. 

> Does anyone have an idea if this is difficult to implement?

defer to experts.

> Does libpq support asynchronous calls?

yes:
http://www.postgresql.org/docs/8.1/interactive/libpq-async.html

If you have deep requirements and/or are extremely speed concerned (and are not concerned about portability), you may
wantto make direct use of liqpq api. 

Merlin

"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:

>> Are there any work done, or plans for implementing asynchronous
>> execution in psqlodbc?
>
> Not sure about future plans, but there is nothing stopping you from
> opening thread in your app and running odbc call that way.

It's not that easy, because the application is using libraries that
are not threadsafe, and I thought it would be best to use ODBC async
functionality, if it's available. Separating just the ODBC calls in
another thread would be too much trouble.

>> Does libpq support asynchronous calls?
>
> yes:
> http://www.postgresql.org/docs/8.1/interactive/libpq-async.html
>
> If you have deep requirements and/or are extremely speed concerned
> (and are not concerned about portability), you may want to make direct
> use of liqpq api.

That's also not an option, since we'd like to have the possibility of
choosing another DBMS.

Oh well, I'll live with blocking functions right now, and if we really
need it, I guess I'll have to try to implement it into psqlodbc.


Tomas