Category Uncategorized

Sybase Tools: License Update (2014)

There have been continuous request for the new license for the tools I have posted here in the past.   I am sorry for not being able to repack all the collections available here with the new license at this time as well as roll up the version updates for the tools.  I will do […]

ASE 15.7: A Fight between Cheetah and Rhino…

It has been quite a long time since I have been able to write anything in this public space.   The reason is that I have been completely absorbed by one of the most exciting projects I have been managing for the last couple of years:   moving the largest ASE site in the country […]

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

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 […]

ASE 15.7 ESD#4 on SPARC…

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 […]

ASE 15.7: ESD#4 Updates….

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 […]

ASE Encrypted Column Options: Performance? Protection? Both…

I’m back again – with yet another ASE feature test. ASE Encryption option has been around for quite a while – since 12.5.3a.  I have been working for more than a decade in a financial institution which was  walking in circles around the question:  to encrypt?  not to encrypt?  In-house?  Application layer?  Third-party tools?  ASE […]

ASE Compression: IO or CPU, which worries you more?

When ASE 15.7 has been announced at 2010 Techwave, Vegas, most of the focus has circled around the new ASE kernel.   We have just started to taste the new ASE optimizer (introduced years ago and still feeling fresh, innovative) and …………. BANGGGGGG …………. another thing to wreck your head on:   threaded kernel.  Gosh! […]