The SQL can be more efficient by only selecting the form time which both should minimize the selection output and improve flexibility. The current naive approach uses Python's regex engine to do this which likely is inefficient. Consider the following points when working this issue:
[ ] Enable various form type checking in all entry points: RESTful and command shell.
[ ] Ensure that the SQL is as secure as possible
[ ] Consider if some amount of the derivable data (filing URLs, corporate info, SIC, address, etc.) can be put into the DB cache in general to further simplify client coding so that call-outs to gather additional data are not required
[x] Mark in the client code which portions could be moved into the DB cache
[ ] When appropriate update decontrol.py and the clients with the required changes
The SQL can be more efficient by only selecting the form time which both should minimize the selection output and improve flexibility. The current naive approach uses Python's regex engine to do this which likely is inefficient. Consider the following points when working this issue: