Our company is the processing of medical data, kaiping machine interface menu to wait a few seconds, the underlying data are treated with temporary table, why other company's products are so fast, the banking system of large amount of data, query, is the need to control program code cache, or need data layer to speed up?

CodePudding user response:

You should first analysis, is a slow interface, or SQL slow? The former are you looking for developers to program and the latter is a part of SQL optimization,

CodePudding user response:

Oh,
I checked the, the underlying data are processed by the temporary table stored procedure, slowly, are processing the original table directly, without any model processing, each query to load the big table for processing

CodePudding user response:

The execution plan, index using? The use of the index? The optimal index type?
Don't is all full table search