Storing Data on the Data-Services Tier

Storing data only on the data-services tier means working with the database rather than against it. This makes it possible to take advantage of database features that can enhance performance and scalability significantly. Some examples of this follow:

• Optimize your application's queries.
• Use indexes to speed searches.
• Use key relationships to take advantage of automatic data integrity enforcement.
• Use stored procedures to increase the performance of business logic in the business tier.
• Don't use components (or worse, script) to filter or sort data.

For more information, see Three-Tier Development Model.