title: MySQL Stored Procedure vs PHP script
body: <p>I'm running a website for a jewellery wholesaler.</p>
  
  <p>The prices on all their products are calculated using the current bullion metal fixes that are updated every night.</p>
  
  <p>Currently, for the website, the calculations are worked out via a php include function, which works fine under current circumstances.</p>
  
  <p>There are around 10,000 products, but the prices are calculated in real-time (ie when the web page is requested). The calculations are simple, but there are lots of them (Around 50+) and i'm worried that an increase in traffic may slow the current script down.   </p>
  
  <p>I'm redesigning the site and was wondering whether it would be beneficial to create a procedure in MySQL to do the calculations instead.</p>
  
  <p>Is this likely to be faster that the current php script?
  Anyone know any good reading reference on using procedures?</p>