MySQL v5.x, just starting working with a group of PHP developers and am responsible for database creation. One of the first items I talked about was using 'stored procedures' to database access as I have years of experience with them on other products. I was responded to with No, No, No, it can't do this, it can't do that, etc.

I have read an article about SP's not being compiled into the database which takes away my performance argument, if it's true. I don't trust everything I read and wanted to get as many opinions as possible as I personally like stored procedures for any database interaction.

Thanks!
From The Dark Side Of The Moon

this is not a technical question, but rather, office power and politics

you are the DBA, just lay down the law

and if you can't, then, well... what was the question again?

of course, if someone says "stored procs can't do such-and-such" then you must either grant an exception or propose a workaround

what did they say you can't do in stored procs?

I somewhat thought this......So there is no technical reason?

It was quick but the developers said that there were problems and they should not be used, which I was thinking W H A T..



this is not a technical question, but rather, office power and politics

you are the DBA, just lay down the law

and if you can't, then, well... what was the question again?

of course, if someone says "stored procs can't do such-and-such" then you must either grant an exception or propose a workaround

what did they say you can't do in stored procs?

@pinkfloyd43 - Your question intrigued me a little because I was always told that they increase performance because the data processing was being done by the server. After looking around a bit here is a snipit I got from MySQL that supports your argument that they should look into Stored Procedures.

In your case if it would be say a 1 to 1 ratio then I would think the DB server would be more than cable at producing the results faster.

I agree 100%. There is an article out on the web somewhere, found it yesterday, in regards to mySQL and it NOT precompiling SQL statements and saving on the server. If I recall correctly is indicated that they are stored associated with a connection? Which did not make alot of sense to me.

Thanks!

Performance improvement is one aspect but if you have all your business logic in stored procedures it means that we can then use different programming languages PHP, JSP, C ... that focuses purely on the presentation.