With Version 1.2 it is now possible to 'dramatically improve the performance' of all subsequent queries performed on previously returned ADO Recordset results from the component by optionally optimizing the original query prior to execution.
1. Filtering Data (Subsets of data)
Use the component to obtain a subset of the original data in an ADO Recordset
Advantages
- Limits the number of round trips to the Database Server by utilizing data already available to the client.
- Removes the need to create temporary Tables/Queries in a Database that are unique to each application user.
- Often quicker than re-querying the Database especially when querying an Optimized ADO Recordset.
- Improved application development productivity, Scalability, functionality and reliability.
- Removes the need for complex nested queries.
2. Data Aggregation
Advantages
- Limits the number of round trips to the Database Server by utilizing data already available to the client.
- Often quicker than re-querying the Database especially when querying an Optimized ADO Recordset.
- A good solution when connections to the Database are not available or have limited access for security or concurrency reasons.
3. Joining Data
- As long as the data source can be represented in an ADO Recordset you can use it to perform a Join.
- Join data from different Databases i.e. SQL Server and Oracle.
- Join data from other non-Database sources i.e. Text and application derived data.
4. Application with no Database
Use the component to provide SQL querying capabilities to an application without a Database.
Advantages
- Offers a flexible solution to providing querying capabilities on saved ADO Recordsets.
- No need to include a Database with the application to provide SQL querying capabilities.
5. Application derived data
Use the component in an application that uses application derived data or a mixture of database and application derived data that requires querying capabilities to aid in the construction of ADO Recordsets consumed by the application.
- Reduction in the complexity of code normally required to manipulate application derived data.
- Improved application development productivity, Scalability, functionality and reliability.