Restrictions for Working with Virtual Widgets
Despite the described advantages resulting from the work with virtual widgets there are special cases where direct data base access via SQL functions is required. These are mainly:
- Operations performing the same update operation for a number of records.
- In contrast to one transaction for each record and prior queries in case of programming with virtual widgets you can execute this transaction more efficiently using the SQL interface.
- Selections over several tables connected by joins.
- When using the SQL interface you can use the data base join optimization.
- Operations on individual table columns if no special widgets are available in the system.
- Especially if the widget used contains a number of fields and thus creating widgets would take extremely long compared to the operation itself.