|
| | TurboDB Studio | >TurboDB VCL < | roPTools | VDP | KALHelp | Downloads | Links | Suche | Kontakt | Impressum | |
|
Howto ... optimize SQL statements?
|
Komponenten TurboDB und TMS Component Pack
»
TurboDB - HowTo
»
Howto ... optimize SQL statements?
|
 |  |
|
Parsing of long queries take their time. To optimize use parameter. Example: TdbQuery.SQL.Text : INSERT INTO MyTable (Field1, MemoField1) VALUES("XXX", :MyMemo) During SQL statement execution the memocontent can be set using TdbQuery.ParamByName('MyMemo').Value := 'this is the 50K memocontent...'; This statement will not be parsed everytime, because it is clear which data needs to be filled in. The data will be written directly. Tested with TurboDB 4 für VCL.
|
