> From: Zbigniew <zbigniew2...@gmail.com> > > Now to the point: considering, that the second column shall contain > about 100-200 different "labels" - so in average many of such labels > can be repeated one million times (or even more)
What about using ENUMs? They have nearly the performance of INTEGERs, but you don't have to maintain a string mapping in your programming logic. :::: Yes'm, old friends is always best, 'less you can catch a new one that's fit to make an old one out of. -- Sarah Jewett :::: Jan Steinman, EcoReality Co-op :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql