Kbase 18406: Tuning Apptivity Data Sources For Better Performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/20/2005 |
|
Status: Unverified
FIX:
1) Do all the data sources need to be executed at startup time? If not then uncheck the "Execute Query on Startup" option for the data source.
2) Do all the data sources need to be read/write or could some of them be read only?
In 3.0 you can use the Data Source property sheet, Options tab to set a data source as read only. In 2.x you need to add a new Server Event for NewQuery make the data source read-only:
public abQuery newQuery (abServer server, abSQLStmtDef arg, Object eventHandler)
{
if (arg.m_ID.equals("dsMyDataSource"))
{
System.out.println(arg.m_ID);
arg.m_readOnly = true;
arg.m_locking = 0;
}
return(null);
}
The arg is an abSQLStmtDef (see online documentation). The m_ID attribute corresponds to the name of the data source so you can be selective about which to make read only. You will want to set NO_LOCK for the READ_ONLY data source also.