Unlike most Data Access solutions, Telerik Data Access is able to working with single entities to define thousands of updates or deletes in an unified LINQ-like API, executed with a single database call.
If you are concerned about performance and comfortable with writing ADO.NET like code, then the Data Access ADO API is perfect for you. It gives you fast low-level access to your data and is especially helpful in data-intensive enterprise applications where performance is key. The benefits of this approach include:
Telerik Data Access comes with a caching mechanism (2nd Level or L2 cache), which reduces the calls made to the relational server. It does this by storing data and query results in the application process. This gives fast retrieval of the commonly used objects, and increases the efficiency and performance of your application. Caching can be fine-grained on a per class basis, implemented in multi-threaded applications and coupled over the network to provide a distributed synchronized cache.
Telerik Data Access retrieves data “lazily” by default, once it is accessed for the first time. Fetch Strategies optimally fetch related entities to reduce the number of database calls. This feature avoids the common performance pitfall that is known as the, "N+1 query problem." Instead of querying for one order and then performing the n order details, a Fetch Strategy can be configured for one optimal query.
Poor network connectivity between a database and an application sometimes slows data access. In such scenarios, Telerik Data Access combines similar database calls in fewer batches. This results in fewer database calls, and does it based on parameters defined by you.
Telerik Data Access helps guarantee speedy access to your data because it does not use reflection. The tool employs a technique called Enhancement, which augments the code the compiler generates by adding the needed persistence, lazy loading and change tracking capabilities.
Copyright © 2002-2014 Telerik. All rights reserved.
Powered by Telerik Sitefinity CMS