goes to show how far behind I am. thanks for the update
Scott Gray sent the following on 8/3/2009 7:25 PM: > They aren't temporary stored procedures on MS unless you're talking 10 > years ago: http://msdn.microsoft.com/en-us/library/aa197533(SQL.80).aspx > And Postgresql makes no mention of functions: > http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html > In both cases they just compile and cache the statement which is what > people call prepared statements. > > Regards > Scott > > On 4/08/2009, at 2:03 PM, BJ Freeman wrote: > >> I meant storeproceedure that are temporary from MS side anyway. >> you may mean the prepared statements that create stored proceedures >> for MS. >> they are Functions for postgresql. >> >> Scott Gray sent the following on 8/3/2009 4:18 PM: >>> I think you meant prepared statements rather than stored procedures >>> there. >>> >>> Regards >>> Scott >>> >>> On 4/08/2009, at 10:59 AM, BJ Freeman wrote: >>> >>>> since ofbiz creates and send a Stored procedure see if it creating more >>>> than one for the same operation. >>> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> >> Systems Integrator. >> > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
