I am thinking to use TVirtualTable as a local 'cache' for some processing I do, before adding data to the main tables in my Firebird DB. The main tables are quite large (millions of records), so aggregating data locally before the final insert/edit makes sense to me.
Since these are in-memory tables, I am concerned about what will happen if we run out of memory? Is there some way I can programmactically determine if these in-memory tables are getting to their limits and I need to process the data out? I don't want the situation where Windows just reports an "Out of Memory" error and everything crashes.
Memory limitations?
Re: Memory limitations?
This feature is not related to the functionality of our driver. You can get the necessary information by using respective Windows API functions.