At 02:01 p.m. 21/01/2014, Hugo Eyng wrote:

>As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application.

Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________