Itqualityassurance
- How do I optimize a large table in SQL Server?
- Which is more efficient multiple MySQL tables or one large table?
How do I optimize a large table in SQL Server?
Use temporary tables
Create temporary table on subset (rows and columns) of data you are interested in. Temporary table should be much smaller that original source table, can be indexed easily (if needed) and can cached subset of data which you are interested in. Pros: Easy to do for any subset of data.
Which is more efficient multiple MySQL tables or one large table?
By the rule, you should make only one Table in case: Content of per-Row is short and otherwise to make more Table for getting to be Fastly! This is a dup -- large tables is almost always better than more tables.
