Kbase P180901: Record creation on the oracle is very slow using Oracle DataServer through WAN
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/18/2011 |
|
Status: Unverified
SYMPTOM(s):
Record creation on the oracle is very slow using Oracle DataServer through WAN
The Oracle DataServer and Oracle client resides on a separate region than the Oracle database server
Creating records on the LAN shown acceptable performance compared to WAN
When ran PL/SQL from SQL*PLUS creating one record at a time to 1000 records from the WAN to Oracle database, it took even more time than the Oracle DataServer client
Creating 1000 records at a time from both SQL*PLUS as well as ABL (using buffer copy from a temp-table), was created by ABL faster than the SQL*PLUS create
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
Oracle DataServer
CAUSE:
The slow performance is contributed by the WAN as well as committing one records at a time to oracle.
FIX:
Use Buffer-copy to create records on the oracle after the records are created on the ABL temp-table. This way oracle will commit once per temp-table records.