MySQL Stored Procedure vs. complex query

by

Stored procedures will give you a small performance boost, but mostly they are for doing tasks that are difficult or impossible to do with a simple query. Stored procedures are great for simplifying access to data for many different types of clients. Database administrators love them because they control how the database is used as opposed to leaving those details to the developer.

Look to indexes and proper table design to get better performance.

More Related Contents:

  1. Doing calculations in MySQL vs PHP
  2. Geo-Search (Distance) in PHP/MySQL (Performance)
  3. MySQL Performance – “IN” Clause vs. Equals (=) for a Single Value [duplicate]
  4. MySQL Query IN() Clause Slow on Indexed Column
  5. Php mysql tabs don’t output [closed]
  6. Update Mysql except when field not null
  7. PHP: What’s the speed difference “template” vs “quote”? [duplicate]
  8. How can I prevent SQL injection in PHP?
  9. UTF-8 all the way through
  10. SQL injection that gets around mysql_real_escape_string()
  11. Can I mix MySQL APIs in PHP?
  12. jQuery Validate remote method usage to check if username already exists
  13. MySQL query to get column names?
  14. PDO get the last ID inserted
  15. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  16. Insert/update helper function using PDO
  17. MySQLi count(*) always returns 1
  18. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  19. Formulas to Calculate Geo Proximity
  20. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  21. Get all child, grandchild etc nodes under parent using php with mysql query results
  22. Laravel Migration table already exists, but I want to add new not the older
  23. Do I really need to do mysql_close()
  24. Saving images in database mysql
  25. convert date string to mysql datetime field
  26. Set PDO to throw exceptions by default [duplicate]
  27. Stored Procedures, MySQL and PHP
  28. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment