MySQL Forums
Forum List  »  Performance

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

Hi

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


Subject
Views
Written By
Posted
tables with many, many columns
5553
October 27, 2004 01:59PM
2932
October 28, 2004 08:44AM
2527
October 28, 2004 09:45AM
2829
October 28, 2004 12:22PM
2480
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.