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?A table cannot contain more than 1000 columns.
Restrictions on InnoDB
Moderator: General Moderators
Restrictions on InnoDB
As written here, it says:
Re: Restrictions on InnoDB
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.
Re: Restrictions on InnoDB
Lol, didn't spot the difference, carelesss.dot wrote:columns are different than rows
Re: Restrictions on InnoDB
absolutely
when the tables get bigger, SQL optimization becomes key to maintaining good performance
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.
Re: Restrictions on InnoDB
What are the SQL optimization options available? Besides query and index?s.dot wrote:absolutely
when the tables get bigger, SQL optimization becomes key to maintaining good performance