First of all, we should optimize the query statement, and try not to check the data columns that can't be used.

Then it is to optimize the database, such as building more indexes, serializing, applying stored procedures, and so on.

Lastly, don't repeatedly check the database, it will be too slow, put the data into

XML or DataTable, and then use it again when you go directly to the XML to check,

this will save a lot of time 。。。。。

This will save a lot of time.