Great post, is it fair to say then that if you are wishing to bulk extract data from a table then you are at the mercy of the original cache design and only way to improve performance would be to change the database design?

Been grappling with cache performance for a couple of years with some of our clients.

https://community.intersystems.com/post/data-extraction-using-sql-odbc