![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| 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? | |||
| | #2 | ||
| "OttawaTrade" <speediercoREMOVE_THIS@yahoo.com> wrote in message news:4CFAf.3669$4g5.696@fe16.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. | |||
| Featured Websites | ||||
|
![]() |
| Tags: mediumtext, penalty, using |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| Featured Websites | ||||
|