Ensure that the logic of the application conforms to
the following guidelines:
Stacks. It
is recommended that you read only as many rows into a stack as are
needed for the current transaction, and then clear the stack when
its data is no longer needed. This ensures maximum memory availability.
You can specify which rows to read into a stack by using the FOR
and WHERE phrases of the NEXT command, and you can clear a stack
using the STACK CLEAR command.
Transactions. Design
your logical transactions to be as small as possible. Also, to prevent
bottlenecks, Maintain closes current user transactions before displaying
a form to an end user. You must ensure the integrity of the transaction.