Enhancement #1345

MySQL Stored Procedures

Added by Dan Shope over 4 years ago. Updated over 4 years ago.

Status:AssignedStart date:05/08/2010
Priority:NormalDue date:
Assignee:Brad Neuman% Done:

0%

Category:-
Target version:2.0

Description

Consider using stored procedures/routines for db queries

Offloads some processing from client end, and could provide an easy way to update queries on tooltron since the db stored code would need updated and, tooltron would not need reprogrammed.

Example;

mysql> CALL tools('81203081');

which replaces
mysql> SELECT tools_6 FROM civicrm_value_roboclub_info_2 WHERE card_number_1 = 81203081

For more information, see:
http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html
http://www.databasejournal.com/features/mysql/article.php/3525581/MySQL-Stored-Procedures-Part-1.htm

History

#1 Updated by Dan Shope over 4 years ago

  • Assignee set to Brad Neuman
  • Target version set to 2.0

Also available in: Atom PDF