Recent company hopes to more than one table in the system the query fields into a user-defined combination query, this means that the user can randomly selected 10 arbitrary n field in the table are combined queries, and presents the results of only contain the user choose the n field, also hope to optimize the query performance, considered using a temporary table, but a temporary table is to determine the field can be realized, what other method can be implemented?

CodePudding user response:

Database service before I do, you look quite complicated, this problem I can help you ask our professional engineer, but if too complicated can't help you solve the free,,, so see you then, have a need to contact me

CodePudding user response:

Personal thought, to see a customer operation time, calculate what table field is easy to read, combined into a temporary table among, and according to the frequency of the query, set the cache time and length, in a word, is based on the user's operation, the best resources to the most needed operation

CodePudding user response:

Consider performance, it is not recommended to use temporary tables, using existing table, table index can optimize query efficiency, efficiency mainly actually is not in the chosen field, but in the definition of the where condition, so the possible existence of the columns of the where clause for establishing good index is a good way to improve query efficiency; As for the custom query method is nothing more than dynamic SQL, users click on the column and table is available, this sqlstring under careful organization can realize, imba,