I am accessing MariaDB 10.0.34 using its C API in a Linux system. I have the following question:
Imagine I have to send a number of MariaDB commands over the C API. In general, will there be much of a performance difference, as far as MariaDB is concerned, between invoking mysql_query() for each command, and accumulating a (potentially long) sequence of commands and invoking mysql_query() for this sequence? Does the overhead concomitant to invoking mysql_query() make it worth the while, in general and at least in principle, to gather together several MariaDB commands before invoking mysql_query()?
I'll be running tests of my own in this respect, but I wonder if people with far more experience in this field than I have could possibly share their experiences and insights in this topic.