SQL database optimization

xiaoxiao2021-04-08  349

In the actual web development. I encountered this situation, the amount of data stored in the database is very large, so there will be a problem, for example: performing a database query, displaying the queryed records with the DataGrid control paging, 50 records per page. Although the DataGrid control can be paised, the principle of the DataGrid control is to load all the data, and then display the top 50 records in the DataGrid, so efficiency is very low. I just consider how to optimize the database. Later I thought of the page display, I showed 50 records on the first page. I called the DataGrid control to load 50 records. In this case, the query speed will be much faster. This is just my first step optimization, then I think so although the query speed is much faster, it is still not ideal. Later, I thought of making a static page, or a memory database, so that the database is much optimized than the previous database, and the accesses are much faster.

转载请注明原文地址:https://www.9cbs.com/read-132756.html

New Post(0)