Some ideas about data storage and query optimization _ database Other

Summarized as follows:

1. Stored procedures:

batch processing of SQL statements, face applications and services, the common continuous operation into batch form.

Solve the bottleneck problem: a large number of SQL query speed slow s

2. Indexing Service:

Establishes the inverted index between the key and the document.

To solve the bottleneck problem: full-text search of key The like '%key% ' statement execution speed is slow

3. Database field index:

Index a database table field.

Solve the bottleneck problem: Slow query speed