Thank you all for your suggestions. So it's very important to make primary fields be as smaller as possible, right? I'm going to change 'isbn' from VARCHAR(100) to VARCHAR(25) and, if possible (I might change my code), from VARCHAR to BIGINT.
By the way, which are optimal values for "key_len" parameter when doing EXPLAIN? Regards, --Charles ISBN field is way too long, I think they just changed it to 13 characters. > Depending on your application leading '0' may be important so you may be > stuck with a character field. As was suggested, loose the '-' and spaces. > I don't think they are standard and I would think its easier to > universally remove them. > ------ > William R. Mussatto > Systems Engineer > http://www.csz.com > 909-920-9154 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
