Optimizing performance of functions that access a database
Thank you Niek.
However, my question was not how to implement caching myself. I was
looking for a component that would provide such caching out of the box.
I thought that the problem is so common that someone in this community
might just know or have some sort of ADO-compliant component
implementing such caching. For example, it could provide exactly the
same interface as ADODB, but cache whole recordsets for configurable
amount of time. Or something like that. This would allow to make our
"legacy code" work faster almost without any rework (let alone new
programming).
Best regards,
Yarik.
|