PDO Blocking?

[necrogami]

We are currently investigating the use of swoole and swoole http server in our application however we are using the OCI8 oracle db driver with PDO. I wanted to know if this is fully blocking or how it would work with swoole?

[deminy]

You will need to test it by yourself, and here is how to write such a test script:

• Create two coroutines. The first one is to connect to Oracle and perform some queries in it. The second one is only to set some flag letting you know if it runs only after the first coroutine finishes or not.
• If the second one runs only after the first coroutine finishes, it means those database operations in the first coroutine run in blocking mode only. If the driver is not coroutine-friendly, you better run those queries by dispatching them as tasks in your Swoole server.

I wrote a script to test the Vertica driver (an ODBC driver), and you can follow the same idea to test the Oracle driver.

[matyhtf]

Now only pdo_mysql+mysqlnd supports asynchronous io, other pdo drivers are synchronously blocking