multiple versus one row

MySQL & MariaDB Other MySQL® Questions
1

From a purely speed-performance standpoint,

would it be faster to read a set of data if each item had its own row (ie using a while loop), or if that dataset were packed into a single row, and then parsed in my script?

Assume updates are infrequent, and the table is very large/trafficed.

2

I really can’t answer such a vague question. In general, you should build a fully normalized schema, and then denormalize IF performance is a problem AND you can prove that this is needed to enhance performance.

3

what about the question is “vague”?

4

Everything that matters. What kind of data? What exactly? You have all kinds of unqualified terms in there like “very large” and “frequent.” In some cases one way is faster, in some cases another is. Don’t answer with details – I don’t want to know. It doesn’t matter. Start with a normalized schema, populate it with realistic test data, run realistic test queries against it, and measure what happens.

5

Your advice sounds good. Thats what i needed. Thanks very much Troy!