Subject Re: [firebird-support] Re: The known limit (1499) in IN clause
Author Dmitry Yemanov
partsi wrote:
> For these kinds of needs, it would be good to support pure in-memory
> based temporary tables. Even though forced writes are off for global
> temporary tables and there is a fast cleanup mechanism for their
> contents, doing these things purely in memory would be the best
> choice.

Currently, temporary tables rely on the operating system keeping their
contents in the file cache and not flushing to disk as long as the
available cache size allows that. IMO, this is more clever than
implement pure in-memory tables and hope that nobody will cause that
memory to be swapped.