…VARCHAR and tinyint (+joined table) columns. In practice you can also often use 4th variant which is not comparable directly, which is using integer value and having value…, located in Minnesota and, to make things slower, we‘ll take those records starting from record #10000 making MySQL to discard …
Post: Why Index could refuse to work ?
September 8, 2006 By 13 Comments
…can see article_id is VARCHAR and this is the problem. Comparing String to Number is not going to use…in your application by using “”. You may ask why MySQL can‘t use index in…in wrong result for some queries. The thing is there are multiple strings possible for single integer value…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
…value. It also can be used…MySQL can do binary search inside the page – kind of jumping in the middle and looking at the key value…in how integer primary key is handled. I can‘t see the index size difference between DEFAULT and 1 values…varchar…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…integer values. There are enough values in the table such that a scan of all rows takes a second or two. mysql…can be shared between views. This example is somewhere in between those two extremes: mysql> create table params ( view_name varchar…
