Visibility, of course, will not improve the speed.
I thought about several Datasources, but what if I have to make optional more fields?
If it is possible to add/remove fields during run-time, why not to:
- remove optional field from TSQLQuery (how?),
- modify TSQLQuery.SQL.text to exclude JOIN related parts,
- call TSQLQuery.Open?