José Pablo Ezequiel Fernández <[EMAIL PROTECTED]> wrote on 01/26/2005 03:49:50 PM:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > After the good comments I've got on this mailing list, I think I have the > structure more or less complete. In some cases I follow the comments, in some > others, I've improvised (hehehe). > So, this is the (explained) structure, what do you think ? Anything I can > improve ? > <<<monster snip>>> > So, in general, what do you think ? > > Thank you! > - -- > Pupeno: [EMAIL PROTECTED] - http://pupeno.com > Reading Science Fiction ? http://sfreaders.com.ar > > [1] I'm making that table public in my web page here: > http://pupeno.com/misc/languagesDB > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.6 (GNU/Linux) > > iD8DBQFB+AJxfW48a9PWGkURAvC8AJ9YeNxHCt+ZgfJrl4nvcbYxCJy+lwCfX4Rk > HxtIQOtUBlI2lQZmMMakoPw= > =IZH6 > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > I think you have an excellent prototype database and can begin your initial site development against it. You may find that you will need an additional column or two but I think it should be good enough to begin working with. Incremental refinements are just part of the fun! Who knows? you may hit an idea that completely changes this design and makes everything else work much faster! Don't let it discourage you. Some of my best database improvement ideas have come from scrapping 80% of one design and reworking it another way. One thing that I know you will be adding soon will be indexes. Pattern your indexes after your most common queries and everything should hum right along. Remember, MySQL generally uses only one index per query (see the EXPLAIN documentation for more details. I also refer you to the manual sections on optimizing). A few, well chosen, multi-column indexes will generally give you better average performance than many single-column indexes. The manual has excellent advice on this topic. Come back to the list if you have any major problems, OK? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
