Kbase 12446: How Sybase uses DBPROCESSES -c startup option
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How Sybase uses DBPROCESSES -c startup option
The -c option sets the maximum number of Sybase DBPROCESSES per user
when you use it to connect to a Sybase database. The Sybase gateway
starts a DBPROCESS whenever it scans a table or a view, or runs a
stored procedure. To minimize the number of open DBPROCESSes,
PROGRESS tries to reuse a DBPROCESS whenever possible.
For example, PROGRESS reuses the DBPROCESSes at the end of a loop
when it fetches all the records, as shown in the following code.
FOR EACH customer:
DISPLAY name.
END.
FOR EACH order:
DISPLAY order-num.
END.
The order loop reuses the same DBPROCESS as the customer loop.
However, in the following code example, PROGRESS uses two DBPROCESSes
because the order loop starts before the customer loop is done.
FIND FIRST cust.
FIND FIRST order.
FIND NEXT cust.
Even though PROGRESS allows you to set a maximum number of DBPROCESSes
a user can start, it has no control over how many Sybase has
available for use.
Progress Software Technical Support Note # 12446