Subject | Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different |
---|---|
Author | Carlos H. Cantu |
Post date | 2019-06-22T20:03:19Z |
RAMMap 1.51 works fine with Windows 10.
Carlos
Migration Guide to Firebird 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/
tycfs> Hi guys,
tycfs> I compared firebird 3 SS performance in windows 10 pro 64 vs
tycfs> Linux mint 19.1 cinnamon 64 bit.
tycfs> Both OS use the same database configurations & almost the same
tycfs> speed ssd. Windows use a bit faster ssd.
tycfs> On windows 10, I have turn off everything than can be turn
tycfs> off, such as bloat ware, unnecessary services, background applications, etc.
tycfs> Database page buffer set to 131072, and page size set to
tycfs> 16384. Both OS have 16GB RAM. File cached threshold, set to 384000.
tycfs> Run query a few times via flamerobin, the results were,
tycfs> Firebird run faster on Mint, at least 20% faster, that was a big different.
tycfs> Don't know why on windows the performance was bad. Perhaps on
tycfs> windows 10, file cached didn't work, cause I saw the disk kept spinning while query ran.
tycfs> This is strange, on Windows 7, with the same database
tycfs> configuration, firebird took about 5GB RAM, which means that file cached work fine.
tycfs> Couldn't inspect actual RAM usage on windows 10 cause RAMMap doesn't work.
tycfs> ------------------------------------
tycfs> Posted by: trskopo@...
tycfs> ------------------------------------
tycfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
tycfs> Visit http://www.firebirdsql.org and click the Documentation item
tycfs> on the main (top) menu. Try FAQ and other links from the left-side menu there.
tycfs> Also search the knowledgebases at
tycfs> http://www.ibphoenix.com/resources/documents/
tycfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
tycfs> ------------------------------------
tycfs> Yahoo Groups Links
Carlos
Migration Guide to Firebird 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/
tycfs> Hi guys,
tycfs> I compared firebird 3 SS performance in windows 10 pro 64 vs
tycfs> Linux mint 19.1 cinnamon 64 bit.
tycfs> Both OS use the same database configurations & almost the same
tycfs> speed ssd. Windows use a bit faster ssd.
tycfs> On windows 10, I have turn off everything than can be turn
tycfs> off, such as bloat ware, unnecessary services, background applications, etc.
tycfs> Database page buffer set to 131072, and page size set to
tycfs> 16384. Both OS have 16GB RAM. File cached threshold, set to 384000.
tycfs> Run query a few times via flamerobin, the results were,
tycfs> Firebird run faster on Mint, at least 20% faster, that was a big different.
tycfs> Don't know why on windows the performance was bad. Perhaps on
tycfs> windows 10, file cached didn't work, cause I saw the disk kept spinning while query ran.
tycfs> This is strange, on Windows 7, with the same database
tycfs> configuration, firebird took about 5GB RAM, which means that file cached work fine.
tycfs> Couldn't inspect actual RAM usage on windows 10 cause RAMMap doesn't work.
tycfs> ------------------------------------
tycfs> Posted by: trskopo@...
tycfs> ------------------------------------
tycfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
tycfs> Visit http://www.firebirdsql.org and click the Documentation item
tycfs> on the main (top) menu. Try FAQ and other links from the left-side menu there.
tycfs> Also search the knowledgebases at
tycfs> http://www.ibphoenix.com/resources/documents/
tycfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
tycfs> ------------------------------------
tycfs> Yahoo Groups Links