I have a very time-consuming SQL (more than 10 minutes) to return the data. However, it runs on a Thread and therefore the MainThread continues to run normally. While SQL is running, the user can shut down the system, and that's where the problem lives. Because the system even closes, however, the process continues to run in the task manager until the SQL returns the requested data.
Is it possible to abort the execution of SQL immediately?
Data:
- Delphi XE 7
- FireDAC
- FireBird
- It's no use changing SQL to get faster, slow, and not you have to get away from it.