SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    $books++ == true matsko's Avatar
    Join Date
    Sep 2004
    Location
    Toronto
    Posts
    795
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does the PACK_KEYS flag really help?

    I out about the PACK_KEYS flag from the program "MySQL query browser". It gives you that choice to use PACK ALL or PACK NONE. The resulting code in the ALTER or CREATE statement is PACK_KEYS=1 or PACK_KEYS=0

    This apperantly speeds up SELECT statements...

    now, I assume that this flag is effective on dynamic tables (which use alot of VARCHAR and TEXT column types). However I haven't really had any experience with it and was wondering if anyone could tell me if it really DOES make any difference.

    Also as I forgot to mention, the drawback is that it slows down UPDATES and DELETE queries.
    I can't believe I ate the whole thing

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    this really only gives you a performace boost when you don't have enough memory to keep all of the indexes in the key cache. if you're worried about speed tweaks like this, i would look at other places first. i have never needed to use this option because i always make sure to allocate enough memory for my key cache.


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
  •