Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.5   10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2    Statistic    FMM    Blog  

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

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


FM.SetDisableContextualMenus - FM.SetThreadName

Feedback: Report problem or ask question.