TalkPHP - View Single Post

Karl · 12-19-2007, 01:46 PM

Make any ID fields unsigned, for example, consider your current thread_forumId field, which is of type tinyint.

As it currently stands, that field can hold 255 values: -128 to 127. However, by making that specific field unsigned, we change that range to 0-255, thus giving us another 128 possible IDs. The same applies for most (if not all?) numeric data types.

12-19-2007, 01:46 PM	#7 (permalink)
Karl The Reckoner Join Date: Sep 2007 Posts: 437 Thanks: 22	Make any ID fields unsigned, for example, consider your current thread_forumId field, which is of type tinyint. As it currently stands, that field can hold 255 values: -128 to 127. However, by making that specific field unsigned, we change that range to 0-255, thus giving us another 128 possible IDs. The same applies for most (if not all?) numeric data types. __________________ Any fool can write code that a computer can understand. Good programmers write code that humans can understand.