SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Evangelist
    Join Date
    Feb 2000
    Location
    England
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am looking for a tutorial on indexes, when they should be used and when they should not be. If there are any costs associated with having them etc... any suggestions? my php books have very little on them ..

    on this subject is there a decent mysql book out there that is realtivly readable (not database techno garble) and perhaps even written from a php coding point in mind? any suggestions?

  2. #2
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    These should help:

    http://www.mysql.com/doc/M/y/MySQL_indexes.html
    http://phpbuilder.net/forum/read.php...=0&thread=6085
    http://www.forwiss.uni-passau.de/cgi-bin/info2html?(mysql.info)MySQL%20indexes

    There isn't any special PHP interface to mySQL indexes, so the basic mySQL docs will be of most help to you.

  3. #3
    SitePoint Enthusiast
    Join Date
    Nov 2000
    Location
    Allentown PA
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ironically, I recently submitted an article on indexes in MySQL to SitePoint. Look for it soon!

    As always, I have to recommend Paul DuBois' book "MySQL". The index/optimization portion isn't huge, but it covers more than my article. A lot of index knowledge just comes from experience, IMO.

  4. #4
    SitePoint Evangelist
    Join Date
    Feb 2000
    Location
    England
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    think i might have to get that then, if you recommend it got to be worth it.

  5. #5
    SitePoint Enthusiast
    Join Date
    Mar 2001
    Location
    Washington State
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Best Practices: Database Indexing
    -----------------------------------------------
    http://phpbuilder.com/columns/tim20010110.php3


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
  •