Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5    Statistic  

FM.SetSQLBatchMode

Sets turbo level for sending SQL in chunks.

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

Parameters

Parameter Description Example value
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

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


FM.ScriptNames   -   FM.SetThreadName

Feedback: Report problem or ask question.




Links
MBS Xojo blog