I have just finished performing a controlled analysis of general performance differences for ASE 15.7 running process and threaded kernel mode on various platforms and hosts (RHEL running on Dell Xeon chips, Solaris running on SPARC M, SPARC T and x64). Although there are quite a few differences, the following image tells the story of […]
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 […]
I am back with the comparative tests: threaded kernel mode versus process kernel mode. I have seen in my earlier tests that process kernel mode seems to get slightly better throughput under the same workload. On the other hand, I have also found that process kernel mode have shown certain types of unwanted behavior absent […]
Although this topic is also somehow related to upgrade issues, it is a bit different from the things I have posted before – and a bit more unofficial… more “playful”… I have been challenged some time ago by one of my customers facing an 12.5 -> 15.7 upgrade deadline and being forced into a pretty […]
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 […]
I have just finished the first round of tests of ESD#4 on Solaris SPARC platform. I have to confirm: the ESD#4 seems to has been finally vaccinated against wasteful reuse of the statement/procedure cache by “inappropriate” use in client-side code. It looks like the painful experience of seeing ASE suffocating unexpectedly under the stress generated […]
ESD#4 has been around for some time. I did not start testing the conditions I am pushing the ASE into with this EBF for several reasons. But now it seems to really be a pity I haven’t done so from the start. After making a few tests with ESD#2 on Solaris x64, and after making similar […]
