On Aug 12, 2010, at 6:28 AM, Norman Palardy wrote:
I'm not certain of the details for the ODBC plugin BUT I do know
that for PostgreSQL, mysql etc they all have an async API as well as
a synchronous one.
The async API's are used and those allow the calling thread/process
to simply wait and do other work while the SQL runs.
I'm fairly certain the ODBC API has async operations like this as well
see http://msdn.microsoft.com/en-us/library/ms713563(VS.85).aspx
Executing Statement Operations Asynchronously
All the databases that REAL currently creates plugins for have some
level of support for async calls so it's possible to send the call
off, yield to other threads while waiting for results, grab results
and yield while doing this , etc so that calls do not block as described
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>