Reusing TSQLScript will results in slowdown
Original Reporter info from Mantis: rvk
-
Reporter name: Rik van Kekem
Original Reporter info from Mantis: rvk
- Reporter name: Rik van Kekem
Description:
When using TSQLScript multiple times (without recreating it) will slow down execution significantly. It seems that the internal FDirectives keeps growing each time TSQLScript.Execute is called.
See also topic
https://forum.lazarus.freepascal.org/index.php/topic,44559.msg314159.html#msg314159
A TSQLScript.Directive.Clear above the .Execute will fix this.
So internally in TCustomSQLScript.DefaultDirectives there should be a FDirectives.Clear called.
Mantis conversion info:
- Mantis ID: 35218
- OS: All
- Platform: All
- Version: 3.3.1
- Fixed in version: 3.3.1
- Fixed in revision: 41801 (#99da1a4a)
- Target version: 3.2.0