如何写出高性能的（How to write high performance）.docVIP

如何写出高性能的（How to write high performance） 1. There is no index or index (this is the most common problem of slow queries and is a bug in programming) 2, I/O throughput is small, forming a bottleneck effect. 3, no calculation column was created, causing the query not to be optimized. 4, lack of memory 5, network speed is slow 6, query the amount of data is too large (you can use multiple queries, other ways to reduce the amount of data) 7, lock or deadlock (which is also the most common problem in slow queries, is a bug in programming) 8, sp_lock, sp_who, active users view, because read and write competitive resources. 9 returns the unnecessary rows and columns 10, the query is not good, there is no optimization, you can optimize queries through the following ways: 1) put data, logs, indexes on different I/O devices, increase the read speed, Tempdb can be placed on the RAID0 before, SQL2000 is not supported. The larger the amount of data (size), the more important it is to improve the I/O 2) divide the table vertically and horizontally, and reduce the size of the table (sp_spaceuse) 3) upgrade hardware 4) according to the query condition, establish index, optimize index, optimize access mode, limit the amount of data of result set. Note that fill factor should be appropriate (preferably using default 0). The index should be as small as possible, using a column with small bytes to index (refer to the creation of the index), and do not create a single index for fields with limited values, such as gender fields 5) improve network speed; 6) expand server memory; Windows 2000 and SQL Server 2000 can support 4-8G memory. Configuring virtual memory: the virtual memory size should be configured based on concurrent services running on the computer. When running Microsoft SQL Server 2000, you can consider setting the virtual memory size to 1.5 times the amount of physical memory installed in your computer. If in addition the full-text search function to install, and intend to ru