The front is given priority to with query
Now is 2 nuclear 4 g cloud server, SQL server 2016 enterprise edition (as if)
Because the data hasn't finished, so also didn't test the efficiency of the query
Because the technology does not pass, so besides indexed, also have no good way to optimize the query, only from the server hardware configuration of
Suppose I will increase the server configuration to 4 nuclear 16 g, is helpful to improve the retrieval efficiency?
You give to other opinions?
CodePudding user response:
We can add memory and CPU speed.CodePudding user response:
According to the query conditions, index on the table is simple, direct and effective method (the premise is the query condition in field support index), try not to build a composite index, but set up multiple single index, so efficiency is much higher,Upgrade hardware directly, of course, will improve efficiency, but also look at the query optimization, if not parallel, then increase the CPU core useless, 4 g memory is really small, 16 gb of memory is stretched, suggest that memory configuration for 25% to 50% the size of the database,