Re: [PERFORM] How number of columns affects performance

2003-08-01 Thread Francisco J Reyes
On Fri, 1 Aug 2003, Ron Johnson wrote: Do all 100 fields *really* all refer to the same *one* entity, with no repeating values, etc? Yes all fields belong to the same entity. I used 100 as an example it may be something like 60 to 80 fields (there are two tables in question). I don't formally

Re: [PERFORM] How number of columns affects performance

2003-08-01 Thread Francisco J Reyes
On Fri, 1 Aug 2003, Josh Berkus wrote: My attitude toward these normalization vs. performance issues is consistenly the same: First, verify that you have a problem. That is, build the database with everything in one table (or with child tables for Nullable fields, as above) and try to run