[firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Hi guys, I compared firebird 3 SS performance in windows 10 pro 64 vs Linux mint 19.1 cinnamon 64 bit. Both OS use the same database configurations & almost the same speed ssd. Windows use a bit faster ssd. On windows 10, I have turn off everything than can be turn off, such as bloat ware, unnecessary services, background applications, etc. Database page buffer set to 131072, and page size set to 16384. Both OS have 16GB RAM. File cached threshold, set to 384000. Run query a few times via flamerobin, the results were, Firebird run faster on Mint, at least 20% faster, that was a big different. Don't know why on windows the performance was bad. Perhaps on windows 10, file cached didn't work, cause I saw the disk kept spinning while query ran. This is strange, on Windows 7, with the same database configuration, firebird took about 5GB RAM, which means that file cached work fine. Couldn't inspect actual RAM usage on windows 10 cause RAMMap doesn't work.
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
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: trsk...@yahoo.com 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
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Thanks for the info. I downloaded ver 1.52, now it works. As I expected, on Windows 10, File System Cached doesn't work. Discussion continue here, as it is a related topic https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/134237 https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/134237
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Thanks for your info. Downloaded ver 1.52, now it worked. On Process tab of RAMMap, firebird.exe took 2,183,484K. On File details tab, database file took 2,603,168K. Don't know, if this means file cached work or not. If file cached worked, then there is something else that make Firebird runs slower on Windows 10. Anto
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Anto wrote: > Thanks for your info. > Downloaded ver 1.52, now it worked. > On Process tab of RAMMap, firebird.exe took 2,183,484K. > On File details tab, database file took 2,603,168K. > Don't know, if this means file cached work or not. > If file cached worked, then there is something else that make > Firebird runs slower on Windows 10. It is worth reading this: http://dyemanov.blogspot.com/2012/03/firebird-vs-windows-file-system-caching.html Helen --- This email has been checked for viruses by AVG. https://www.avg.com
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Hello, Don't know, if this means file cached work or not. It works. I recommend to do several experiments with different Pafe buffers and FileSystemCacheThreshold values (Buffers > FileSystemCacheThreshold , Buffers < FileSystemCacheThreshold ), and check RAMMap. Try to do it with and without restart of the computer. If file cached worked, then there is something else that make Firebird runs slower on Windows 10. Windows 10 is a desktop OS, and it demonstrates slowness in so many cases, caused by so many reasons, so I would not use it as a server, until there is no other choice. I personally experienced slowness on one of my own desktops, and perfect performance on the another one. Better just stay out from this lottery. Try to make experiments with Windows Server, it will make more sense. Regards, Alexey Kovyazin IBSurgeon Anto
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
Hello, I have tried to enable LargeSystemCache on Windows 10, no effect. With or without LargeSystemCache, the second query run on Windows 10 was about 33% faster than the first run, I guest File Cached did work although still saw disk activity. But even the second query runs, it was still about 20% slower than Linux Mint. I will avoid Windows and use Linux for firebird if it is possible. Regards, Anto.