Is now millions of table, expected annual growth data is on the order of millions,
If fuzzy query, is first from the database fuzzy query, or directly from the database about data, the client then fuzzy retrieval,
SQL server 2008 database,
Winform client,

CodePudding user response:

Full-text index, but I think you to update the database, (/≧ del ≦)/~ ┴ ┴

CodePudding user response:

Take out a data cache is better then the client to retrieve

CodePudding user response:

1. The optimized query
2. The database cache
3. The client cache