Results 1 to 4 of 4

Thread: Best PHP/MySQL Practices

  1. #1
    Registered Mike's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    2,755

    Best PHP/MySQL Practices

    It's a cold summers night, I'm bored, so let me ask all of the PHP/MySQL programmers what their best practices are for efficiency? Whether it be table design, functions, whatever, what are your best practices?

    Let me just add, I've decided I want to alter the way I code. I've got a lot better over the last year or two, but still I don't think I'm "ultra efficient".

    What are your best tips?

    Mike
    Don't you just love free internet games ?

  2. #2
    Senior Member AndyH's Avatar
    Join Date
    May 2004
    Location
    Australia
    Posts
    553
    Use indexes
    Avoid table sorts
    Use InnoDB tables for ones which are causing lock waits (table vs row level locking)
    Log slow queries
    Keep your data as small as possible
    Sacrifice normalization for performance
    New website released. ya rly!

  3. #3
    Registered The New Guy's Avatar
    Join Date
    May 2004
    Posts
    283

  4. #4
    Senior Member AndyH's Avatar
    Join Date
    May 2004
    Location
    Australia
    Posts
    553
    Thanks for that. A few good tips in it.
    New website released. ya rly!

Similar Threads

  1. php/mysql hosting
    By Kyle in forum Web Hosting & Servers
    Replies: 8
    Last Post: 06-23-2006, 09:50 AM
  2. Hello, we can provide you with PHP/MySql help
    By phpmysqlteam in forum The Marketplace
    Replies: 0
    Last Post: 11-11-2005, 07:28 AM
  3. URL rewriting - best practices
    By dvduval in forum Search Engine Optimization
    Replies: 1
    Last Post: 06-10-2005, 10:17 AM
  4. Blogging Software PHP/MySQL
    By aj8 in forum Community Management
    Replies: 6
    Last Post: 03-06-2005, 12:48 PM
  5. Coding a PHP/MySQL CMS
    By jbiggs77 in forum Website Programming & Databases
    Replies: 12
    Last Post: 11-09-2004, 02:27 PM

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
  •