03.01.2015 03:08, André Knappstein wrote:
I created a test table on both old and new server to play with updates
and inserts (~ 150.000 records)
Performance with 2.5.3 x64 on Win2008 is constantly
changing, but at best its some 8 seconds and worst even 2 minutes!
Performance with
Hi Andre,
- get some sleep
This is the key to find a solution, never optimize anything in a bad mood :)
WinSrv2008R2 is a perfect Windows Server, when properly configured.
Regards,
Alexey
Thank you Dmitry.
Seems I found the solution to the real problem parallel to your
posting of the message (BBU failure report resetting cache parameters).
The difference on old hardware (2.9 - 3.2) seconds probably is due to
inaccuracy in the very simple test methods. And, yes,
Operations (new Server)
Read : 2.247
Writes : 5.960
Fetches: 2.476.240
Marks : 807.922
Operations (old Server)
Read : 8.516
Writes : 6.084
Fetches: 1.602.243
Marks : 582.584
Guten Tag André Knappstein knappst...@beta-eigenheim.de [firebird-support],
am Samstag, 3. Januar 2015 um 10:45 schrieben Sie:
Stripe size is 64K, btw.
much too big , best size for a stripset ist same as DB Page Size
Strip Set 64Kb means that the controller will read and write Blocks of