SQL query commits

Alan DeKok aland at deployingradius.com
Wed Mar 28 12:52:03 CEST 2018

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.


  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.

More information about the Freeradius-Users mailing list