improve typing speed

SELECT * from t anywhere, replace "*" with a specific field list, and do not return any fields that are not available.20. Try to use table variables instead of temporary tables. If the table variable contains a large amount of data, be aware that the index is very limited (only the primary key index).21. Avoid frequent creation and deletion of temporary tables to reduce the consumption of system table resources.22. Temporary tables are not unusable, and they can be used appropriately to make ce

Improve the compilation speed of c ++ builder by pre-compiling header files C++ Builder is one of the fastest C ++ compilers. It can be said that it is also the fastest win32C ++ compiler. In addition to the speed, the performance of C ++ builder is also based on other C ++ compilers. However, many delphi programmers still cannot handle the compilation

automatically opened when the boot, click "–" to delete the project. The fewer applications in this list, the better, which is very helpful to speed up startup.4. Excessive background runningIn addition to the three reasons above, when you run too much in the background, Apple can't handle tasks quickly and easily.Figure IV: Activity Monitor Solution: Activity Monitor End ProcessActivity Monitor lets you see all the programs that are running in the b

, operators provide the bandwidth is the bottleneck, and different levels of wireless routers in the wireless LAN to give users different transmission speed and the range of signal coverage. So for the average home users, the current mainstream 54M wireless router can fully meet our demand for BT download. 　3. Turn off the SSID The SSID (Servicesetidentifier) is typically the local area network name that is broadcast by the AP or wireless router, a

There are several ways to improve page loading speed:(i) Reduced HTTP forcing(1) Increase the parallel connection(2) Merge resource files: Combine multiple small CSS and JavaScript files into one large file, so that the page will be loaded with the related resources of the page, reducing the HTTP request, thus speeding up the page loading speed(3) Use CSS Sprite:

We have previously introduced ways to improve the speed of the system by optimizing the configuration of the desktop environment, but in other respects we can also configure it to improve the speed of the system. First, improve the data transmission performance of hard disk

Sometimes JDBC does not run fast enough, which allows some programmers to use database-related stored procedures. As an alternative, try using the statement batch feature to see if you can execute all the SQL at the same time to improve speed. The simplest form of a stored procedure is the process of including a series of SQL statements that can be used together to manage in the same place and

table, which avoids longer locking of the system tables.25. Avoid using cursors as much as possible, because cursors are inefficient and should be considered for overwriting if the cursor is manipulating more than 10,000 rows of data.26. Before using a cursor-based method or temporal table method, you should first look for a set-based solution to solve the problem, and the set-based approach is generally more efficient.27. As with temporary tables, cursors are not unusable. Using Fast_forward c

table, which avoids longer locking of the system tables.25. Avoid using cursors as much as possible, because cursors are inefficient and should be considered for overwriting if the cursor is manipulating more than 10,000 rows of data.26. Before using a cursor-based method or temporal table method, you should first look for a set-based solution to solve the problem, and the set-based approach is generally more efficient.27. As with temporary tables, cursors are not unusable. Using Fast_forward c

Application and activity in the OnCreate are optimized, basically no time-consuming operation, but after starting the application will still flash a white background, and then into the splash page, compared to QQ, Weibo and other clients, After the click is instantaneous response Splash start page, where is the difference.In fact, even if you oncreate do not do anything, will still flash white screen, because the initial parsing interface takes a certain amount of time, the solution is to custom

-modified:sun, -The - the: -: -Gmtconnection:keep-Aliveexpires:mon, -The - .: +: -Gmtcache-control:max-age=43200Content-encoding:gzip(3). Picture successfully compressedCurl-i-H"Accept-encoding:gzip, deflate" "http://wwww.xxxx.com/1_mr_smile2014.jpg"HTTP/1.1 $Okserver:nginx/1.9.1Date:sun, -The - -: A: $gmtcontent-type:image/Pnglast-modified:thu, atThe - -: -: -Gmtconnection:keep-Aliveexpires:tue, -Sep - -: A: $Gmtcache-control:max-age=2592000Content-encoding:gzip(4) JS file successfully co

gzip_comp_level 6; #设置需要压缩的MIME类型, non-set values are not compressed gzip_types text/plain application/x-javascript text/css Application/xml text/javascript application/x-httpd-php image/jpeg image/gif image/png; #跟Squid等缓存服务有关, On words will add "vary:accept-encoding" gzip_vary off in the header, #IE6对Gzip不怎么友好, do not give it gzip gzip_disable "MSIE [1-6]\.";Change to post code such as:4. Reload Nginx;5. Test whether Nginx compression is enabled:(1). Page successfully compressed(2). css file

Compression of Web content (making your customers more "cool") After two of the above methods, I believe that your PHP application performance has been greatly improved, now from another aspect to consider: download speed. If your app is only running within the company, all customers use 100MB/S Ethernet to connect to the server, which may not be a problem, but if your customer has a slow modem connection, you should consider using the content compre

Memcachedb and memcached engine cannot improve the query speed of the example search. Http://blog.s135.com/post/357/#entrymore Since no one at home and abroad has written how to install memcache_engineArticleSo I wrote this article according to my own compilation and installation steps. Memcache_engine is a storage engine for MySQL 5.1 databases. It allows users to access memcached through standard SQ

I want to improve the speed and efficiency in development! Eclipse shortcut keys that cannot be forgottenEclipse shortcut keysWe recommend that you use Ctrl + 1 to quickly fix the problem)CTRL + D: Delete the current rowCTRL + ALT + ↓ copy the current row to the next row (copy added)CTRL + ALT + ↓ copy the current row to the previous row (copy added) Alt + ↓ interaction position between the current row and

Install APC (alternative PHP Cache) to improve PHP parsing speed This article refers to "high-performance PHP development" to make the next record PHP must perform the 5 steps required, whether from the command line or from a WEB server. The Zend engine must read the file from the file system, scan its dictionaries and expressions, parse the file, create the computer code to be executed (called Opcode), a

Empty IE cache can effectively improve the speed of the computer access to the Web site now IE version of the first check the computer's IE is which version of view IE browser version of the way to open any page click on the top of the help to select the Internet Explorer automatic pop-up window will show the version of IE browser (IE) Empty IE Caching method Please open any one of

How to use XP system disk partition application to improve read and write speed 1. Partition and format the hard disk in one minute Right-click on "My Computer" and select "Manage" command. In the Computer Management window that opens, expand Computer Management → storage → disk management. You can then see the partition of the current hard disk in the right pane. Right-click on unassigned disk space and