Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-23 Thread trsk...@yahoo.com [firebird-support]
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

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-23 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-23 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
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

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-22 Thread trsk...@yahoo.com [firebird-support]
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

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-22 Thread trsk...@yahoo.com [firebird-support]
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

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-22 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
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

[firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

2019-06-22 Thread trsk...@yahoo.com [firebird-support]
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,