Restrictions on InnoDB

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
TheOnly92
Forum Newbie
Posts: 19
Joined: Thu Jan 15, 2009 6:05 am

Restrictions on InnoDB

Post 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?
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Re: Restrictions on InnoDB

Post by s.dot »

columns are different than rows
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
TheOnly92
Forum Newbie
Posts: 19
Joined: Thu Jan 15, 2009 6:05 am

Re: Restrictions on InnoDB

Post by TheOnly92 »

s.dot wrote:columns are different than rows
Lol, didn't spot the difference, careless :P , anyway, does the size of the table make an impact on the performance.
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Re: Restrictions on InnoDB

Post by s.dot »

absolutely
when the tables get bigger, SQL optimization becomes key to maintaining good performance
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
TheOnly92
Forum Newbie
Posts: 19
Joined: Thu Jan 15, 2009 6:05 am

Re: Restrictions on InnoDB

Post 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?
Post Reply