Category LWP

LWPs: 12.5.4, 15.7, The Throughput Differences…

April 3, 2013 · by · in ASE 15.7, LWP, Statement Cache, Sybase ASE · Leave a comment

I have just finished a round of throughput checks for LWP performance between versions 12.5.4 and 15.7 – threaded & process kernel mode.   The comparison is a bit “unfair” since I compare 12.5.4 with statement cache disabled (it was in its diapers then), and 15.7 with the statement cache enabled + functionality group enabled […]

ASE 15.7: Prepared Statements and ASE Statement/Procedure Cache, Configuration Impact

March 19, 2013 · by · in ASE 15.7, LWP, Prepared Statement, Procedure Cache, SAP Sybase, Statement Cache, Sybase ASE, Uncategorized · 2 Comments

So we are back with the same issue:   statement cache/procedure cache behavior under the stress of executing a high volume of prepared statements.   I have just finished another round of tests around this issue (which has caused quite a lot of troubles in the past releases of ASE) and I want to share and […]