Page 1 of 1
Restrictions on InnoDB
Posted: Sat Apr 17, 2010 11:54 pm
by TheOnly92
As written
here, it says:
A table cannot contain more than 1000 columns.
But the fact is that I have a table with more than 7,000,000 rows with 16 GB of data, what's the catch here?
Re: Restrictions on InnoDB
Posted: Sun Apr 18, 2010 12:00 am
by s.dot
columns are different than rows
Re: Restrictions on InnoDB
Posted: Sun Apr 18, 2010 12:41 am
by TheOnly92
s.dot wrote:columns are different than rows
Lol, didn't spot the difference, careless

, anyway, does the size of the table make an impact on the performance.
Re: Restrictions on InnoDB
Posted: Sun Apr 18, 2010 12:42 am
by s.dot
absolutely
when the tables get bigger, SQL optimization becomes key to maintaining good performance
Re: Restrictions on InnoDB
Posted: Sun Apr 18, 2010 12:58 am
by TheOnly92
s.dot wrote:absolutely
when the tables get bigger, SQL optimization becomes key to maintaining good performance
What are the SQL optimization options available? Besides query and index?