Subject memory use with large views ?
Author bemmel2003

My view could contain 10 million records, but My application always
queries this view so a maximum of 100 records will be in the result
set. How does Firebird deal with this on the server ? Only those 100
records memory-load, or will it need space for 10 million records ?