How to improve the efficiency when search data from more than 1000000 records?
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Hi everyone, My company has a website, use ms sql server. One table has more than 1000000 records. When users search data from this table(such as search records which contain the word "school" in NewsTile field. And the server often occurred deadlock error. How can I improve it? Thanks. P.S. The table has these fields: NewsID NewsTitle NewsContent NewsClickTimes NewsInsertTime
========================================= Make friends with you all. My Blog, welcome
天气常如二三月，花技不断四时春。