Prepared Statement vs. Stored Procedure

php mysql stored-procedures prepared-statement
John picture John · Oct 13, 2008 · Viewed 21.3k times · Source

If you are using php5 and mysql5, is there a substantial advantage to using stored procs over prepared statements? ( i read somewhere you may not get substantial performance gains from mysql5 stored proc)

Answer

Toby Hede picture Toby Hede · Oct 13, 2008

They are not really the same thing - with stored procedures, your database logic resides inside the database. Prepared statements basically avoid re-parsing queries if they are called multiple times - the performance benefit can vary greatly.

The choice to use one or the other is really dependent on your specific situation. I don't really use stored procs anymore as I like having all of my logic in one place.

Related questions

How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the best way to do this? -MySQL client version: 4.1.11 -MySQL Server version: 5.0.45 Here is my stored procedure: DELIMITER $$ DROP FUNCTION IF …

Read More
How to write a stored procedure using phpmyadmin and how to use it through php?

I want to be able create stored procedures using phpMyAdmin and later on use it through php. But I dont know how to? From what I know, I found out that we cannot manage stored procedures through phpMyAdmin. What other …

Read More
Laravel 5.1 How do you create a MySQL stored procedure with migration

Hello I'm trying to create a stored procedure using Laravel 5.1 migrations. So far I tried with DB::connection()->getPdo()->exec(), DB::raw() and DB::unprepared(), but no luck. Here's how my code looks like: use Illuminate\…

Read More