Kbase 15683: Is the rcode compiled against an Oracle database bigger? Yes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Is the rcode compiled against an Oracle database bigger? Yes
Typically the r-code generated when compiling against an Oracle
database is slightly bigger then when compiled against a PROGRESS
database.
The SQL statements (actually just the WHERE & ORDER BY clauses) are
stored as ascii text, which is typically larger than what is compiled
for PROGRESS. The only significant r-code changes for PROGRESS
version 8 are Join by server and sql select passthru.
Join by server should not have much impact on r-code size. For SQL
select passthru (each statement that can 'potentially' be passed thru
is compiled twice. Once the old version 7 way and once the new
version 8 way. SQL select statements now take about twice the r-code
space then they previously needed).
Field list will occupy a small amount of
additionaly r-code space (at most about 36 bytes). Each
FIND/CAN-FIND/OPEN QUERY/FOR EACH/DO PRESELECT, will occupy 18 bytes
more than in version 7.
4-29-96 ik
Progress Software Technical Support Note # 15683