|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster 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 us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
02-23-2005, 09:44 PM
|
#1 |
|
salad tossing sig guy
Join Date: Apr 2002
Location: mrthumbs*gmail.com
Posts: 11,702
|
stupid mysql question
What happens with my database performance if i define a field as TEXT
although 90% of the entries will be used for small messages (for which varchar would be most suitable) ? |
|
|
|
02-23-2005, 09:51 PM
|
#2 |
|
Confirmed User
Join Date: Sep 2003
Posts: 8,713
|
The performance will be all good but they will decrease with the data since text take more memory. Not some thing that you should feel.
__________________
 TrafficCashGold Paying Webmasters Since 1996! Awesome Conversions! Fast Weekly Payments! Over 125 Tours! |
|
|
|
|
02-23-2005, 09:54 PM
|
#3 | |
|
salad tossing sig guy
Join Date: Apr 2002
Location: mrthumbs*gmail.com
Posts: 11,702
|
Quote:
Ok.. but lets say.. i store 10.000 records with the word "hello" in a text field and i store 10.000 records with the word "hello" in a varchar field on some other database.. no problem there? The only issue i can think of is that for example a varcahr(4) reserves actual 4 bytes of memory while a 4 character text field has a default of 64 bytes or something.. whether you use it or use less.. That would kill performance in the long run. |
|
|
|
|
|
02-23-2005, 11:58 PM
|
#4 |
|
Too lazy to set a custom title
Join Date: Jan 2002
Location: Holland
Posts: 9,870
|
It doesn take memory space it takes diskspace
__________________
Don't let greediness blur your vision | You gotta let some shit slide icq - 441-456-888 |
|
|
|
