SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict SwordsmanX's Avatar
    Join Date
    Sep 2005
    Posts
    211
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Performance Issues (need tutorials!)

    Hi there
    I'm developing my first php+mysql application and it's going pretty well, however, one thing I'm concerned about is performance.
    What are the most important principles to keep in mind when i code?
    I figure the most important are:

    1- trying to use the least required data type (ie using tinyint over integer where possible etc)
    2- trying to use as few queries as possible
    3- using a caching system like phpcache

    could you steer me in the right direction by providing some links to tutorials or articles about mysql performance?
    I'd also like to know the fastest php functions to get the job done etc..
    Thanks!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    more important than those three rules is --

    0. index, index, index

    there are some great resources listed here: MySQL Optimization
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •