Professional Web Applications Themes

Penalty of using MEDIUMTEXT? - MySQL

My text is about 30k bytes to 200k bytes, mostly fall between 100k bytes. TEXT is 65K Charators, so it is 130K bytes. MEDIUMTEXT is much larger Should I break the text into 2 or 3 or should I declare the field MEDIUMTEXT? Will it slow down the database or take too much space?...

  1. #1

    Default Penalty of using MEDIUMTEXT?

    My text is about 30k bytes to 200k bytes, mostly fall between 100k bytes.

    TEXT is 65K Charators, so it is 130K bytes.
    MEDIUMTEXT is much larger

    Should I break the text into 2 or 3 or should I declare the field
    MEDIUMTEXT? Will it slow down the database or take too much space?




    OttawaTrade Guest

  2. #2

    Default Re: Penalty of using MEDIUMTEXT?

    "OttawaTrade" <speediercoREMOVE_THIS> wrote in message
    news:4CFAf.3669$4g5.696fe16.lga...
    > My text is about 30k bytes to 200k bytes, mostly fall between 100k bytes.
    >
    > TEXT is 65K Charators, so it is 130K bytes.
    > MEDIUMTEXT is much larger
    Should be 2^24 which is 16MB.
    > Should I break the text into 2 or 3 or should I declare the field
    > MEDIUMTEXT? Will it slow down the database or take too much space?
    I would go ahead and use MEDIUMTEXT. It shouldn't make any meaningful
    difference in performance, and the storage requirement is just one more byte
    per field, which is insignificant compared to the 30-200KB data.

    The additional computation (and programming complexity for you) to keep the
    fields broken apart like you describe would be much worse, IMHO.

    Regards,
    Bill K.


    Bill Karwin Guest

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139