386 Part III . Administration Optimizing Databases and (Remote web server)
386 Part III . Administration Optimizing Databases and Tables Certain optimizing techniques can change the structure of databases and tables to make them operate more efficiently. In addition, certain statements can optimize tables with performance enhancements such as defragmentation. The use of indexes will help performance immensely on large datasets. MySQL stores indexes and data in separate files to maximize efficiency. Adding an index (or creating one with a table) will help when performing operations on the data; that way MySQL need only look at a subset of the data for the correct result. If there is a PRIMARY KEY index on the table, it should be a short task to maximize speed. If you frequently search on multiple columns, index the columns with the most used column being the first in the list. However, don t make unnecessary indexes. The EXPLAIN statement can assist in determining when an index might be useful. The EXPLAIN statement is used with a SELECT statement. For example, Figure 14-13 uses the EXPLAIN statement to show indexes used by a SELECTstatement. Figure 14-13: A description of two tables in the ecommerce database along with an EXPLAIN statement to examine the SELECT statement being used to find the first and last names of customers
We recommend high quality webhost to host and run your jsp application: christian web host services.