jaymc Posted September 19, 2007 Share Posted September 19, 2007 I've been reading up on field types and am just wondering the effect it will have in regards to performance For instance, if I have an integrar field which will only have a number as high as 45 the following field types apply int tinyint mediumint smallint tinyint would be the best to use as it caters for numbers from -127 - 127 How would I benifit from setting my field to tinyint as apposed to being lazy and careless and just using int Im just wondering whether its worth tralling through my tables and making the field types better in relation to the data thats going to be stored feedback would be great Quote Link to comment Share on other sites More sharing options...
fenway Posted September 19, 2007 Share Posted September 19, 2007 For UIDs, use INT UNSIGNED. For everything else, choose unsigned intelligently. Forget about speed, it makes no difference. Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 19, 2007 Author Share Posted September 19, 2007 Cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.