…this blog post. When is a matching datatype not really a matching datatype? If you guessed that it has something…not null; ERROR 1146 (42S02): Table ‘oops4.dos2′ doesn’t exist (root@localhost) [oops4]> show tables; +—————–+ | Tables_in_oops4 | +—————–+ | dos1 | | dos3 | …
Post: Picking datatype for STATUS fields
August 9, 2008 By 24 Comments
… may run into is slower JOIN performance especially for MyISAM Tables. Though it is solvable as well. The benefit of using… with ENUM is adding new values using traditional way (ALTER TABLE) causes table rebuild which is not acceptable for many environments. It… numbers in the application directly. I prefer to have the table though because correctly architecting your queries you can use such…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… to potentially drop another index (more memory) and since the datatype is small you can fit more of that data from… instead of FIRST fetchign the product ID from the product table via name you can totally skip this step and just… on the client and then query it from the buyers table. Less IO is a good thing. One drawback is that…
