MySQL Forums
Forum List  »  Performance

tables with many, many columns
Posted by: Daniel Carvalho
Date: October 27, 2004 01:59PM


We are developing a php script that will do database read-only operations on tables that have more or less 1200 columns each with numeric values, some of the tables also have something around 15000 rows.

We would like to know what can we do to these tables to make better the performance of the queries. will it be fine if we just use them like they are now, or should we split the variables on the columns on diferent tables as rows?

Options: ReplyQuote

Written By
tables with many, many columns
October 27, 2004 01:59PM
October 28, 2004 08:44AM
October 28, 2004 09:45AM
October 28, 2004 12:22PM
October 30, 2004 04:21AM

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.