MySQL Forums
Forum List  »  Performance

No.of Column vs Performance
Posted by: senthil kumar
Date: September 10, 2007 11:54PM

Whether performance is affected according to the no.of columns in a table. ex:

Querying the table having 100 columns and
Querying the table having 200 columns and
Querying the table having 300 columns

My application will increase the no.of column dynamically. so i decided to use views with huge(greater no.of columns) tables.

I came to know that mysql will support more than 3000 columns in a table.

table : pid col1 col2 ...... col200
view 1: pid col1,col5,col13,col100. (only 5 columns)
view 2: ....

Is this db settings is correct for performance issue?

Share your stuff .

Thanks in advance.

S.S.Senthil Kumar

Options: ReplyQuote


Subject
Views
Written By
Posted
No.of Column vs Performance
2509
September 10, 2007 11:54PM
1361
September 11, 2007 07:18AM
1373
September 12, 2007 12:16AM
1277
September 12, 2007 05:36AM
1261
September 12, 2007 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.