SAP Knowledge Base Article - Preview

3152257 - Text insertion speed is poor - Logical io grows exponentially with table size.

Symptom

  • Poor text insertion speed when inserted table size grows. 
  • In 99,5 % of the inserts : logical io (set statistics io output) is 7 io and in 0,5 % of the inserts : logical io is much more.
  • The bigger the table, the larger the logical io for example:

                table 20 GB : logical io  500
                table 60 GB logical io 1500
                table 110 GB , logical io 3000
                table is 300 GB , logical io 18 000 

  • In an insertion without text field, the logical io is always the same.


Read more...

Environment

SAP Adaptive Server Enterprise  (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

826211,CR826211,CR 826211,CR#826211,text,insertion,logical io,slow,performance, poor, speed , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.