Any versions with Stored Procedures?

[D_M_S]

I realize that Sugar does not use stored procedures and this gives some flexibility in choosing the backend database.

But has anyone tried to produce a version of Sugar that uses SPs for MySQL? Surely someone out there has been interested in doing this. My guess is that it exists in a "private" install since it would be difficult to do as a module or a single script. But in case I'm wrong, I'd like to know if there is a version out there that uses stored procedures.

[salesagility]

Never been a fan of stored procedures ... loosely coupled architectures are compromised by SP ... IMHO SP's are a way for proprietary vendors to tie in customers.

[D_M_S]

WHAAAA????

There's a performance gain to be had with stored procedures . . . that's why they exist.

[salesagility]

I personally like to keep the database access to storage and retrieval and move most of the business logic out of the database into a middle tier. Medium and long term benefits accrue. There may be some short term benefits from SPs but that's what they are ... short term gain for long term pain.

[D_M_S]

Indeed, it may not be ideal for the long term. But then again . . . what's the long term? It's fun to play around with Sugar and do a fresh install, but in the practical world, I don't think companies prefer to update their business-critical CRM on a continual basis. If I have a stable CRM with no compelling reason to upgrade for, say, 2 years, then the work (and benefits) of SPs might very well be worth it.

Again, I'd be highly surprised if a client out there has not already attempted this. Surely someone out there is leveraging stored procedures.