Hi Peter!

When I hear about that kind of improvement, I'm thinking that the optimizer in your case didn't produce the best plan. Show us the select statement and the plan generated by both Firebird 1.5 and 2.1.

I assume you have executed the statement several times in both versions, that you've retrieved the entire result set (as opposed to only the first few rows), and that the execution time you report are typical figures for the statement (e.g. if you executed the statement in Fb 1.5 when a sweep was going on, then that could influence the speed, but then it would be difficult to reproduce the slow execution).

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Peter Bailey
Sent: 5. desember 2010 05:09
To: Firebird - support
Subject: [firebird-support] V2.1.3 Faster than a speeding bullet

Hello Firebird supporters

I recall, (I think), that V2.1 is expected to be about 40% faster than
V1.5, so I am very curious about some test results that I have generated.

The scenario is that I have a Delphi program that generates an XML file
from a Select Query.

Linking to fbembed.dll (gds32.dll) gives the following execution times
for the Select Query:
V1.5.5: 437 seconds
V2.1.3: 0.078 seconds
That makes V2.1.3 aprox. 5,600 times faster than V1.5.5!

Fantastic numbers for V2.1, but why is it so?

It may be relevant that the FB database is "small" - 6.5MB - and
therefore could easily be loaded into RAM, (4GB). The database structure
is ODS 10.1.

Thanks for any information.
Peter