Performance and Tuning

LightSpeed makes it easy to work with your persistent data as .NET objects, abstracting away many details of your application’s use of the database.  In practice, however, no application layer can completely abstract away the database.  To get good performance, it’s important to understand what is happening at the level of the database connection and the database engine, and what options you have for improving performance at this level.

Controlling How Entities Load

Controlling How Entity Data Loads

Understanding Named Aggregates

Bulk Updates and Deletes

Batching

Caching

Database Hints

Measuring Performance

Intercepting Queries