Karen, An educated guess would be 1 row with 11 columns. That is 11 integers vs 30 integers for the other.
Of course, creating two test databases amd populating them with a good size dataset would give the ultimate answer. Dennis McGrath -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of tellef Sent: Thursday, October 31, 2002 10:19 AM To: All Subject: Table size comparison RScope doesn't give me the kind of information I'm interested in so I thought I'd find out if anyone here knows the answer to this. I have the option of storing data 2 different ways and I'm wondering which way would create the SMALLER table. Nulls won't be much of a consideration and both tables would work for me equally well. For each piece of information I need to track, the table would either have (all columns are integer): 1 row in a table with 11 columns 10 rows in a table with 3 columns This has the potential of being a HUGE table so size of the table is a prime consideration, even if I sacrifice in other areas (ie true relational model). Karen ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
