| 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 |
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
- Dialog.SetTop
- FM.GetSQLBatchMode
- FM.InsertRecord
- FM.InsertRecordQuery
- ProgressDialog.Hide
- ProgressDialog.Reset
- ProgressDialog.SetProgress
- ProgressDialog.SetTopText
- ProgressDialog.Show
- ProgressDialog.Update
Blog Entries
This function is free to use.
Created 17th September 2016, last changed 12nd November 2018
