I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize =
20 in the firebird.conf
as suggested in:
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html
Hugo
Em 21/01/2014 12:06, Roland Turcan escreveu:
Yes, I am interested too.
What was the key to get rid of this problem?
Thanks in advance.
<<< 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI
"fabi...@sci10.com.br" >>>
How you solved your problem?
*De:* firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng
*Enviada em:* terça-feira, 21 de janeiro de 2014 10:24
*Para:* firebird-support@yahoogroups.com
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your answer.
You are right.
But the "Windows 64 file cache performance" was a problem, as said Sean.
Só 'reserving' 10GB as a RAM DRIVE grant that I would have always
available RAM.
But now I solved the 'cache performance' and I will not need RAM DRIVE
anymore.
Even so, the FB performance is not compatible to the hardware used to
run it.
Em 20/01/2014 23:12, Helen Borrie escreveu:
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
__________________________________________________________
--
Atenciosamente,
Hugo Eyng
How you solved your problem?
*De:* firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng
*Enviada em:* terça-feira, 21 de janeiro de 2014 10:24
*Para:* firebird-support@yahoogroups.com
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your answer.
You are right.
But the "Windows 64 file cache performance" was a problem, as said Sean.
Só 'reserving' 10GB as a RAM DRIVE grant that I would have always
available RAM.
But now I solved the 'cache performance' and I will not need RAM DRIVE
anymore.
Even so, the FB performance is not compatible to the hardware used to
run it.
Em 20/01/2014 23:12, Helen Borrie escreveu:
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
__________________________________________________________
--
Atenciosamente,
Hugo Eyng
/--
Best regards, TRoland
/http://www.rotursoft.sk
http://exekutor.rotursoft.sk
--
Atenciosamente,
Hugo Eyng