Is there any real benefit in creating a storepd proc as ooposed to running adhoc sql statements in Sybase?
My understanding used to be that stored procs (SP) are precompiled. And Sybase documentation claims recompiling takes only a fraction of a second. Doesn't that make the benefit of precompiling meaningless?
Also, this link claims there is no precoimpiling at all
So DBAs/DB developers out there should I prefer SPs to SQL queries in Sybase ASE 15? Why?