DROP [CACHED] TABLE does not clear the .data file. The data remains with an
index root that is no longer used or accessed. Will have to address this and
a few other issues such as the free list very soon.
There have been comments that the indexing used for the cache is not
efficient etc. but the
Campbell's tests in the past have helped focus the development effort into
areas that need improvements most. These new tests are no exception.
Following some internal discussion and tests by Karl, I have been
concentrating this week on reengineering some of the core classes that are
responsible
On The Subject Of Prepared And Callable
Statements:
Over the last few weeks, there has been occasion to discuss
implementing server-side statement cursors, not only to allow updatable and
efficient (engine side) scollable result sets, but also to possibly increase
performance for oft used S
