List:General Discussion« Previous MessageNext Message »
From:Zheng Li Date:February 28 2012 3:59pm
Subject:does the number of column affect performance
View as plain text  
for example
there are 2 tables to save same data
table A has 10 columns: a primary key column and 9 blob column
table B has 2 columns : a primary key column and 1 blob column which includes all data in
2nd~10th columns of table A

are there any differences in performance when selecting, inserting, updating, and deleting
data.
Thread
does the number of column affect performanceZheng Li28 Feb
  • Re: does the number of column affect performancePaul DuBois28 Feb
    • Re: does the number of column affect performanceMichael Dykman28 Feb
    • Re: does the number of column affect performanceZheng Li29 Feb
      • Re: does the number of column affect performanceBaron Schwartz29 Feb
        • Re: does the number of column affect performanceJohan De Meersman1 Mar
    • Re: does the number of column affect performanceZheng Li9 Mar
      • Re: does the number of column affect performanceZheng Li9 Mar