sql statement to fast 1. unnecessary columns do not need to check out; 2 as a condition of the query column indexing; 3. if the query table data is greater than 5 million data, the table should be created at the beginning of the establishment of table partitioning, based on the sub-table to check;

The most important is the transmission of the amount of data transmitted to the foreground page to try to simplify the reduction of the transmission of the amount of data, such as the time of the data is best not to pass, the provisions of their own order, based on the order of the foreground to generate the corresponding time; have to pass can be turned into milliseconds