Tooltron: Issueshttps://roboticsclub.org/redmine/https://roboticsclub.org/redmine/redmine/favicon.ico2010-05-08T17:28:39ZRobotics Club
Redmine Enhancement #1345 (Assigned): MySQL Stored Procedureshttps://roboticsclub.org/redmine/issues/13452010-05-08T17:28:39ZDan Shopedshope@andrew.cmu.edu
<p>Consider using stored procedures/routines for db queries</p>
<p>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.</p>
<p>Example;<br /><pre>
mysql> CALL tools('81203081');
</pre><br />which replaces<br /><pre>
mysql> SELECT tools_6 FROM civicrm_value_roboclub_info_2 WHERE card_number_1 = 81203081
</pre></p>
<p><em>For more information, see:</em><br /><a class="external" href="http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html">http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html</a><br /><a class="external" href="http://www.databasejournal.com/features/mysql/article.php/3525581/MySQL-Stored-Procedures-Part-1.htm">http://www.databasejournal.com/features/mysql/article.php/3525581/MySQL-Stored-Procedures-Part-1.htm</a></p>