Subject | Firebird 1.5.2 slower pages than PG |
---|---|
Author | buppcpp |
Post date | 2005-06-08T16:03:14Z |
I've performed a quick test with FB
> 1.5.2 and PG 8.0 on win32. On second run FB is faster than PG,except the
> GROUP BY clause (where PG slightly wins). But the first run (whenour page
> cache is empty) makes a very big difference: PG is about 20x fasterthan FB.
> I don't believe in miracles, so I suspect some in advance databasecaching
> on the PG side, but neither of the PG backend processes occupiedmore than
> 10MB of RAM whilst the test table was 50M. I think this should beHas this been written up yet? Hopefully for 1.5.2 and 2.0.
> investigated a bit further.
>
>
> Dmitry