Ben mysql yeniyim ve benim yeni veritabanı için MySQL veritabanı yapısı ile ilgili bir seçim var. Ben sahip olabilir:

tablo1: (ID, text1, metin2, text3, metni4, text7 kadar)

VEYA

tablo1: int değerleri tablo 2 benzersiz dizine bağlantı nerede (ID, int1, int2, int3 ... int7 kadar)

Tablo2: (ID2, metin)

So basically, should I put all text in columns in a single table or saparate and store index values in 1 table and the text data in a second table... queries will be given ID code, to return strings text 1 to text 7. Table will be large, about ~1 million ID's (meaning table 2 if method 2 is used would have ~7 million entries)

Sizce daha hızlı olacağını yöntemi?

EDIT1: Each text is 250 letter characters in length. EDIT2: To clarify, I am given the ID and the query to the table would be getting all 7 text items for that ID. This is the only query that will be done on the tables and the only information ever required. Just need to know which would be faster to use. If neither, please offer a better way!