Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

FM.SetSQLBatchMode

Sets turbo level for sending SQL in chunks.

Component Version macOS Windows Linux Server iOS SDK
FM FMSQL 6.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "FM.SetSQLBatchMode"; Value )   More

Parameters

Parameter Description Example
Value The chunk size.
Default is 1, but 10 or 50 is usually faster.
1

Result

Returns OK or error.

Description

Sets turbo level for sending SQL in chunks.
For use in FM.InsertRecordQuery.
(others could be added)

Our plugin can send several SQL commands in one chunk which makes some operation much faster.

Examples

Move records, 50 inserts per chunk:

Set Variable [ $r ; Value: MBS( "ProgressDialog.Reset") ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetTitle"; "Please wait." ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetTopText"; "Copying records..." ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Show" ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetProgress"; 0 ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Update" ) ]

Set Variable [ $r ; Value: MBS( "FM.SetSQLBatchMode"; 50) ]
Set Variable [ $r ; Value: MBS( "FM.InsertSetUpdateProgressDialog"; 1) ]
Set Variable [ $r ; Value: MBS( "FM.InsertRecordQuery"; ""; "dest"; $FieldNames; ""; "SELECT \"f1\", \"f2\", \"f3\", \"f4\", \"f5\", \"f6\", \"f7\",… ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Hide") ]

See also

Blog Entries

This function is free to use.

Created 17th September 2016, last changed 12nd November 2018


FM.SetDisableContextualMenus - FM.SetThreadName