Normalize database or not? Read only MyISAM table, performance is the main priority (MySQL)
Posted
by hello
on Stack Overflow
See other posts from Stack Overflow
or by hello
Published on 2010-05-14T22:08:40Z
Indexed on
2010/05/14
22:14 UTC
Read the original article
Hit count: 142
I'm importing data to a future database that will have one, static MyISAM table (will only be read from). I chose MyISAM because as far as I understand it's faster for my requirements (I'm not very experienced with MySQL / SQL at all).
That table will have various columns such as ID, Name, Gender, Phone, Status... and Country, City, Street columns. Now the question is, should I create tables (e.g Country: Country_ID, Country_Name) for the last 3 columns and refer to them in the main table by ID (normalize...[?]), or just store them as VARCHAR in the main table (having duplicates, obviously)?
My primary concern is speed - since the table won't be written into, data integrity is not a priority. The only actions will be selecting a specific row or searching for rows that much a certain criteria.
Would searching by the Country, City and/or Street columns (and possibly other columns in the same search) be faster if I simply use VARCHAR?
© Stack Overflow or respective owner