SQL query commits

[Alan DeKok]

On Mar 28, 2018, at 2:43 AM, mustafa mujahid <mustafa.mujahid at outlook.com> wrote:
> 
> I wanted to know how the SQL queries defined in sql.conf run "commit" on the DB, right now each time a query is executed on the DB, it is committed as well.. I would like to know if it is possible to send a commit to the DB after say 10 SQL transactions.

  No.

  You can write the SQL statements to a log file, and then run radsqlrelay to write them to SQL.  That will let you do batched transactions.

  But that also means you lose many of the benefits of trying multiple queries that's in the rlm_sql module.

  Alan DeKok.