View Single Post
Old 12-07-2007, 01:06 PM  
schneemann
Confirmed User
 
Join Date: Oct 2006
Posts: 749
Quote:
Originally Posted by drjones View Post
If your host offers postgresql, instead of mysql you can use stored procedures for a lot of queries, that might save you on hits to the db.

Not sure what kind of support mysql has for stored procedures these days, if any.

And yea, read up on database normalization.
Stored procedures are available as of MySQL 5.0
http://dev.mysql.com/doc/refman/5.0/...rocedures.html
__________________
Deranged World
schneemann is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote