Sybase ASE Stored Procedure sp_jdbc_getprocedurecolumns and Performance

Categories: Infrastructure, Programming

My employer has a large Java-based application which uses Sybase ASE as its data store, and a mysterious stored procedure sp_jdbc_getprocedurecolumns (which we never call directly) is causing performance problems. It took quite a lot of work to track down why; if you’re having similar problems then see the explanation here.